Skip to Main Content

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!

DB trigger not working because of latest patch updates

user11289444Mar 10 2016 — edited Mar 10 2016

Hi,

We have two systems , from source system data gets inserted into one of the custom table in destination system. While inserting a db trigger  will fire.

As per the latest patch updates We see the db trigger is on editioning view instead of table, because of this change our db trigger is not firing when we load data from source system, but this works fine, if we insert directly from destination system..

Can some one suggest what are the next steps.

I was going thru the user guide, they suggested to replace the db trigger from table to editioning view..

Can some one please suggest me how to proceed on this change.

Thanks in advance.,

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2016
Added on Mar 10 2016
7 comments
1,698 views