Re: copy a table with a long raw column

Now you have a problem ...
I tried to copy really long and really long raw (>32KB) with PL/SQL or SQL - nothing works. Last week I've seen somewhere on the Oracle Homepage, that with 7.3.x writing really long columns is not supported. The only way to do this is OCI, but it's a hard way!

Alex

sofresud wrote:
>
> I would like to copy some rows of a table that contains a LONG RAW column to
> another table.
> this is on Oracle 7.3.4
> i tried :
> insert into DESTINATION Select Col1, Col2, Col3 from SOURCE where
> Col1=MYFILTER;
>
> but as i thought it doesn't work ! cause the Col2 is a raw format.
> do u have a idea how can i do a such thing, SQL or PL/SQL procedure ?
>
> thank you
Received on Wed Dec 01 1999 - 03:10:26 CST