Skip to Main Content
Forums

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!

trigger before update-cancel update

vasileiosMar 14 2011 — edited Mar 14 2011
i have a before update trigger on a table, i have an if statement inside, i want if the "if statement" is valid to cancel the update so that it doesnt happen.

how do i cancel the update in the trigger?what must i write?

thks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2011
Added on Mar 14 2011
#general-database-discussions
6 comments
2,706 views