Transfering a long raw column to a long raw column...

From: Damas <jbdamas_at_concept.fr>
Date: 22 Oct 1998 10:21:22 GMT
Message-ID: <01bdfda5$8d47b540$370e17ac@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 Thu Oct 22 1998 - 05:21:22 CDT