Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 9 2011
Added on Jul 12 2011
0 comments
112 views