Re: Triggers and CLOBs

Tim Dry wrote:
>
> I have a table with a CLOB column that I need to work with every time
> that it is updated. I can detect the actual update based on the
> update of a different column in the same table. The code that
> performs the necessary actions is in a procedure.
>
> When I have the procedure read the CLOB, I get the mutating triggers
> problem. When I pass the CLOB in from the trigger to the procedure, I
> get Oracle internal errors since Oracle 8.1.7 doesn't allow me to read
> CLOBs within a trigger. Is there a better/different solution? Thanks
> in advance.
>
> -Tim Dry

An upgrade to 9 is one way of doing it :-)

If you're staying on 8, then one way is to use dbms_job to submit a job to do the work as part of the trigger. Takes a little coordination etc but it can be done depending on the contraints

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"