Problem - LONG data type

[greyone]

I need help for the following.

Problem :
I am trying to INSERT data into a table by selecting data from another table which is having one column of data type LONG.

It gives me the following error.

ORA-00997: illegal use of LONG datatype

I am getting the same message when using same in PL/SQL procedure.

Is there a solution to this. Please help

 

[listener22]

If you are storing the intermediate results of the select statement,
the limits are (v 7) 32767 bytes into a varchar2 variable, and 32760
byes into a pl/sql long variable. Jim

oracle, vb