copy LONG RAW data with Oracle7

From: Holger Hinze <Holger.Hinze_at_t-online.de>
Date: Fri, 15 Jan 1999 17:18:25 +0100
Message-ID: <369F6A51.6FD6@t-online.de>

I want to copy data containing a column of type LONG RAW. The statement:

  insert into TABLE1(COLID, COLDATALONG)

     select 2, COLDATALONG from TABLE1 where COLID = 1;

fails in Oracle7 with error ORA-00997: illegal use of LONG datatype. I found the solution:

  declare cursor CUR_TEST is

     select COLID, COLDATALONG from TEXT where COLID = 1;   begin

     for CUR_DATA in CUR_TEST 
        loop
           insert into TABLE1(COLID, COLDATALONG)
              values (2, CUR_DATA.COLDATALONG);
        end loop;

  end;

which seemed to work. But further tests showed, that it doesn't work with very long data.
It seems, that the long datafield is cut at a limit, which must be somewere near 64k.

Does anyone have another solution of the problem?

Holger Received on Fri Jan 15 1999 - 10:18:25 CST