exporting table data with long raw column

[tonyfaunt]

I am using Oracle 8.1.7 and I have to develop an Oracle procedure to export data from a table with a long raw column.
When the data in the long raw column is less than 32767 I can select into a varchar2 variable but when the data in the long raw column is larger than 32767 I have struck a brick wall. The table export / import tools in PLSQL Developer does the job but I am not sure it is all done in PL/SQL code.
Can anyone help

 

[Marco Kalter]

I don't think it's possible to access more than 32KB of a LONG or LONG RAW in PL/SQL. In SQL you can access all 2GB of course, and this is what PL/SQL Developer's import/export functions do.

In 8.1.7 you have CLOB's and BLOB's as alternative.

------------------
Marco Kalter
Allround Automations