Re: how do I insert a LONG varaible into a table

Gene Gurevich wrote:
>
>
> Anybody knows how do I insert a value of a LONG column from
> one table into another? I tried running
> INSERT INTO table_1 (long_field1)
> SELECT long_field2
> FROM table_2;
> and got a 997 error "illegal use of a LONG type".
>
> I've been thinking of saving the data in a temp variable and
> then inserting this variablt into a table... Any other options?
>

Unfortunately, this is all you can do. LONG types cannot be used in sub-queries, functions and just about anything else you can think of. Write a quick PL SQL procedure to select the long into a local variable and then do an insert with the variable.

Casey Received on Mon Jan 20 1997 - 00:00:00 CST