Re: Transfering a long raw column to a long raw column...

Oracle does not allow this type of insert with long columns. There are some new PL/SQL procedures designed to move raw data, but I have not tried them. The only way my company got around this was to write a client application in Visual Basic (could be anything) that used getchunk and appendchunk to transfer the long raw data. It was not real fast, but it worked.

    --Gary Waterman

Damas wrote in message <01bdfda5$8d47b540$370e17ac_at_jbd-workstation>...
>
>I'm programing a PL SQL procedure for
>
>transfering a long raw column to a long raw column.
>
>Ex.:
>
>procedure p_inicol(rec number)
>is
>begin
>insert into SIG.POSTT#B
> (
> B1#ID,
> B#COLNAME,
> B#BLOB
> )
>select
> B1#ID,
> B#COLNAME,
> B#BLOB
> from POSTT#B
> where B1#ID=rec;
> commit;
>end p_inicol;
>
>Oracle says to me : ORA-00997: Utilisation illégale du type de données LONG
>
>Have you an idea please?
>
> Jean-Benjamin Damas
Received on Fri Oct 23 1998 - 14:58:08 CDT