dml inside a trigger - is it possible to rollback/savepoint??
419712Feb 26 2007 — edited Feb 27 2007Hi 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