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: Bill Bell <billb_at_deletethis.ti.com>
Date: Mon, 11 Apr 2005 14:39:20 -0500
Message-ID: <d3ejp8$3te$1@home.itg.ti.com>


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.com
Received on Mon Apr 11 2005 - 14:39:20 CDT

Original text of this message

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