Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Beginner: trigger doesn't rollback insert
In message <7d5fe.4900$pe3.2731_at_newsread3.news.atl.earthlink.net>, Assaf
<assaf_tamir.no-spam_at_no.sp-am.hotmail.com> writes
>My BEFORE INSERT trigger checks for invalid quantities.
>
>
>
>If QTY <= 0, a raise_application_error is issued and outputs a message to
>the user. I was also expecting the error to roll back the insert but the
>record is still inserted into the table.
>
>
>
>Manual inserts via SQL*Plus seem to be OK (i.e., rolled back by trigger).
>But the trigger does commit records inserted through stored procs.
>
>
Does the stored proc trap the exception and then rollback? That would be
the correct way to do it.
>
>How can I prevent the trigger from performing the insert? Any pointers?
>
>
>
>Thanks!
>
>
>
>- Assaf
>
>
>
>
-- Jim Smith Because of their persistent net abuse, I ignore mail from these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw For an explanation see <http://www.jimsmith.demon.co.uk/spam>Received on Sat May 07 2005 - 12:21:26 CDT