Using triggers with CLOBS?

From: Steve Barlow <Steve.Barlow_at_amaral.com>
Date: Tue, 25 Jul 2000 13:21:17 -0400
Message-Id: <10569.112908@fatcity.com>

I am trying to do this auditing trigger for tables with CLOB's, and I just saw the metalink saying that CLOB is READ ONLY in the trigger. To resolve the error message ora-22275, remove CLOB from trigger... which is exactly what I really want to do...

Basically the triggers I created worked well for tables with NO CLOB's...

However, when the trigger sees a CLOB column, I was trying to do the same thing, running another stored proc to insert the CLOB value into the table AUDIT_HISTORY_CLOB with the CLOB value... Can't do it....

Can you please let me know what approach would you take?

Also, how do you setup to do parallelism for running triggers and stored procs?

Thanks, Received on Tue Jul 25 2000 - 12:21:17 CDT