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
Would you by chance have an example of how this could be done.
How do you intialize the counter?
Frank van Bortel wrote:
> 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, Tel# (214) 480-1433 Fax# (214) 480-2356 Bill Bell Email = billb_at_ti.comReceived on Mon Apr 11 2005 - 14:39:20 CDT
![]() |
![]() |