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

whitegoose_at_inorbit.com wrote:
> I have searched high and low for an answer to this, can anyone help?
>
> I am writing a BEFORE INSERT trigger on a table with a calumn called
> COMMENTS which is of type CLOB. I need to assign a value (another CLOB
> from a different table) to :new.COMMNETS - but I understand this is a
> problem in Oracle 8.
>
> There must be a way to do this. I am aware of DMBS_LOG but I can't
> manage to get it working.
>
> Does anyone have a solution?

What version
What problem
What DDL
What DML
What does DBMS_LOG, which doesn't exist, have to do with anything?

PS: No column should ever be named COMMENTS. If it is, for example, the person table, name the column PERSON_COMMENTS.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)