Mike Cretan wrote:
> "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.
>
>
>
Because a 'delete from big_table' will cause 2 billion - 1 exceptions
to be raised...
And you all have to click them away... sigh.
--
Regards,
Frank van Bortel
Received on Tue Apr 12 2005 - 04:20:43 CDT
