Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Delete Trigger - Constrain Delete to 1 Row
"Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message
news:d3edji$8aj$1_at_news6.zwoll1.ov.home.nl...
>
> Semiconductor Division of Texas Instruments?
>
> I would think some thing like:
> - a row level trigger, adding 1 to a packaged variable
> - a statement trigger, reading the packaged variable, if >1, err off.
>
> --
> Regards,
> Frank van Bortel
Nice one.
But how about initialising the package variable in a pre-statement trigger, then raising the exception within the row level trigger if > 1
Mike Cretan. Received on Mon Apr 11 2005 - 15:01:30 CDT