illegal use of LONG datatype ORA-06512

[sahernandez]

I got this error, when I try to

Insert into table1(long_field )
select longvalue_field from table2;

This insert is inside into package.
Somebody knows about this error..
thanks..
Alexander

 

[cliousa]

You can use the SQL*Plus COPY command to get LONG data from one table to another. This will work remotely as well.

There is only one limitation - LONG data greater than 64k will be truncated after the 65535-th character. This is a SQLPlus limitation.


Hope that helps,

clio_usa - OCP DBA
------------------

http://www.dbaclick.com