Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: how do I insert a LONG varaible into a table
Casey Husar wrote:
>
> 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
The PL SQL procedure will work only for values smaller than 32K. For me it seems that PL/SQL has been written in an 15-Bit language.
Martin Received on Fri Jan 24 1997 - 00:00:00 CST