Insert LONG type to another table by trigger: Internal error

From: Jeff Y. Y. <yuanjeff_at_yahoo.com>
Date: 13 Mar 2002 15:24:06 -0800
Message-ID: <a2bc9497.0203131524.1aa8eb12@posting.google.com>

I need to copy the data in a LONG type column of one table to a LONG type column of another table by a trigger. I have tried different ways in Oracle 8i without success. The code basically is:

create or replace trigger UpdateFixer
after INSERT OR UPDATE on t_prod for each row DECLARE
t_rowid rowid;
begin

	insert into t_fixer (id, document) values
        (:new.id, :new.document)
	returning rowid into t_rowid;  
        -- do something else using t_rowid

end;

DOCUMENT is a long type in both tables. I got the following message:

ERROR at line 1:
ORA-00600: internal error code, arguments: [kdtlcdef-1], [], [], [], [], [], [], []
ORA-06512: at "PRODDTA.UPDATEFIXER", line 6 ORA-04088: error during execution of trigger 'PRODDTA.UPDATEFIXER'

Is there a work around to make it work? Please help. Thank you so much. Received on Wed Mar 13 2002 - 17:24:06 CST