LONG RAW in cursor?

From: M Mueller <melissa_mueller_at_yahoo.com>
Date: 14 Mar 2003 11:09:42 -0800
Message-ID: <ac8fbcca.0303141109.1c4e40c3_at_posting.google.com>


Running Oracle 8.1.7, trying to move data from one table to another (both have the same owner). column_c is a LONG RAW. It appears that it transfers all of the first row of data except the LONG RAW column then errors out with a SQLCODE of -1. The error is as follows:

declare
*
ERROR at line 1:
ORA-20100: Error -1 while inserting records into table_1: ORA-06512: at line 15

Any insight/suggestions would be greatly appreciated.

Thank you!
Melissa

declare
 cursor C1 is

            SELECT column_a, column_b, column_c, column_d, column_e, column_f

            FROM TABLE_1;
    BEGIN

        for crec in C1
        loop
            BEGIN
            insert into table_2(column_a, column_b, column_c,
column_d, column_e, column_f)
values(crec.column_a, crec.column_b, crec.column_c, crec.column_d, crec.column_e, crec.column_f);
            commit;
            EXCEPTION
            when others
            then
                    raise_application_error(-20100,'Error
'||SQLCODE||' while inserting records into TABLE_1: ');
            END;
        end loop;

    END; Received on Fri Mar 14 2003 - 20:09:42 CET

Original text of this message