Re: CLOBs in Triggers - assigning to :new.XXXX

From: <whitegoose_at_inorbit.com>
Date: 24 May 2005 22:02:06 -0700
Message-ID: <1116997326.744907.222870@o13g2000cwo.googlegroups.com>

The Version is 8.1.7

The problem is that Oracle 8 does not allow :NEW.XXXX to be updated from a trigger where XXXX is a CLOB field.

My apologies, it was a typo - I meand DBMS_LOB - a package used for mainpulating LOBs and CLOBs.

I can't provide DML and DDL because I'm not after a solution to a specific problem, I just wanted to know if anyone had a solution for updating CLOB fields from a trigger on the same table. (eg. Yes you can do it - use DBMS_LOB.WRITE to update the field)

I do not have a choice about the name of the COMMENTS field.

Thanks,
Josh. Received on Wed May 25 2005 - 00:02:06 CDT