Re: Beginner: trigger doesn't rollback insert

From: Dave <x_at_x.com>
Date: Sat, 07 May 2005 15:52:45 GMT
Message-ID: <hv5fe.27082$G8.22680@text.news.blueyonder.co.uk>

"Assaf" <assaf_tamir.no-spam_at_no.sp-am.hotmail.com> wrote in message news:7d5fe.4900$pe3.2731_at_newsread3.news.atl.earthlink.net...
> 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.
>
>
>
> How can I prevent the trigger from performing the insert? Any pointers?
>
>
>
> Thanks!
>
>
>
> - Assaf
>
>
>
>

code? Received on Sat May 07 2005 - 10:52:45 CDT