whitegoose_at_inorbit.com wrote:
> 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.
Which means it is really important to have a version of Oracle
that supports LOBs.
--
Daniel A. Morgan
Relational theory is not something that is simply a nice-to-have.
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed May 25 2005 - 00:11:55 CDT
