Skip to Main Content

CLOB and Trigger in Apex

10500Jul 12 2011
I have an APEX form with a textarea based on a CLOB column in the underlying table. I have a post update row level trigger that inserts changed fields into another table. For some reason when this CLOB column is changed via the APEX form, the trigger inserts NULL values into the other table for this CLOB column. However, when we change the column in a client like say SQLDeveloper the trigger fires and the changed CLOB column is inserted into the other table.

Any insight into this would be helpful.
Post Details
Added on Jul 12 2011