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>
values(crec.column_a, crec.column_b, crec.column_c, crec.column_d, crec.column_e, crec.column_f);
END; Received on Fri Mar 14 2003 - 20:09:42 CET
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