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!

Trigger on commit: work around.

oratechsApr 7 2015 — edited Apr 7 2015

Hi All,

I have a situation where I need to send an email to a group when a record is inserted in a table, wanted to do this using triggers initially, but the problem is, trigger fires even without committing the data.this will not work for me because i may rollback the transaction. is there a workaround for this. how can i do this. help is appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 5 2015

Added on Apr 7 2015

5 comments

1,517 views