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: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 11 Apr 2005 19:57:23 +0200
Message-ID: <d3edji$8aj$1@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

Received on Mon Apr 11 2005 - 12:57:23 CDT

This message: [ Message body ]
Next message: amerar_at_iwc.net: "PL/SQL Question - Passing Arrays"
Previous message: Bill Bell: "Oracle Delete Trigger - Constrain Delete to 1 Row"
In reply to: Bill Bell: "Oracle Delete Trigger - Constrain Delete to 1 Row"
Next in thread: Bill Bell: "Re: Oracle Delete Trigger - Constrain Delete to 1 Row"
Reply: Bill Bell: "Re: Oracle Delete Trigger - Constrain Delete to 1 Row"
Reply: Mike Cretan: "Re: Oracle Delete Trigger - Constrain Delete to 1 Row"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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