Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> CLOB Trigger Help!!!???

CLOB Trigger Help!!!???

From: Kyle Lai <Kyle.Lai_at_amaral.com>
Date: Mon, 31 Jul 2000 21:27:08 -0400
Message-Id: <10575.113438@fatcity.com>


Hi,

How do you get around insert/update trigger for CLOB column???

I created an Insert/Update trigger to audit the activities on a table with CLOB column.

All I want to do for this trigger is to copy the :NEW value to the Act_Hist table.

However, I get ORA-22275 error preventing me copying the :new CLOB value to the Act_Hist table...

Any around this????

Please help!!!

Thanks in advance. Received on Mon Jul 31 2000 - 20:27:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US