Update/Insert CLOB in a trigger

Hi,

Have anyone figured out a way around to update/insert CLOB inside a trigger?

Based on Metalink, CLOB can be READ-ONLY inside a trigger, so I always got ORA-22275 error...

What I had tried is :

1. Create a stored procedure to handle the CLOB insert/update (didn't help)
2. Used DBMS_LOB.COPY in the trigger, did not help at all...

I really appreciate any input.

Thanks, Received on Thu Jul 27 2000 - 16:00:45 CDT