Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Delete Trigger - Constrain Delete to 1 Row

Re: Oracle Delete Trigger - Constrain Delete to 1 Row

From: Mike Cretan <nospamthanks_at_nowhere.com>
Date: Mon, 11 Apr 2005 20:01:30 GMT
Message-ID: <uIA6e.8001$5F3.1582@news-server.bigpond.net.au>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US