Skip to Main Content
Forums

SQL & PL/SQL

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.

Null CLOB value when inserting into table from trigger

WP v.2Sep 6 2018 — edited Sep 8 2018

Hey all,

I have an "after insert or update" trigger on a database table that has a clob column. In the trigger I'm checking to see if the new clob value is different than the old value and if it is, I'm inserting both the new and old value in a separate table which is used for a change log. The comparison works fine and a row is indeed inserted into the change log table. However, the row in the change log table has null for the new clob value, while the old value gets inserted correctly. What is the cause of this and what can I do to insert the new clob value correctly?

The Oracle db version is 12.1.0.2

Thanks,

Bill

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 6 2018
Added on Sep 6 2018
#12c, #insert, #oracle, #trigger
12 comments
5,630 views