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

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 19 May 2005 04:04:19 -0700
Message-ID: <1116500659.216101.301510@z14g2000cwz.googlegroups.com>

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?

Your Oracle version?
What is the problem in Oracle 8? Please be more specific and provide an error message.
There isn't a dbms_log object. Do you mean dbms_logmnr package?

Regards
/Rauf Received on Thu May 19 2005 - 06:04:19 CDT