Skip to Main Content

Oracle Forms

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!

dml inside a trigger - is it possible to rollback/savepoint??

419712Feb 26 2007 — edited Feb 27 2007
Hi folks

I have a when-button-pressed trigger.
Inside the trigger, i have an insert statement to a master table
then numerous insert statements in detail.

if any of the insert raise exception, system shows the error message
but the previous inserts are not rolled back/commited.
If the button is again clicked which shows the Unique constraint in header table.

Is it possible to rollback the dml if any exception is raised while doing the numerous inserts???

Appreciate your immediate help

Regards
Muthu
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 27 2007
Added on Feb 26 2007
9 comments
772 views