Oracle Database Discussions

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!

Database trigger after insert - update table over database link

suadhmJul 5 2016 — edited Jul 8 2016

Hi,

I'm writing database trigger that will do update of one row in some table on remote database over DB Link when I do insert of one row in table on my local database.

I have some trouble writing part with exception.

I need to write exception that will send me a mail when some error on update that remote database happened.

I need some advice how to do that.

This post has been answered by AndrewSayer on Jul 5 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 5 2016

Added on Jul 5 2016

#general-database-discussions, #trigger

28 comments

4,269 views