RE: Development question - Trigger to disallow UPDATE without WHERE clause?
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: 'Phil Jones' <phil@xxxxxxxxxx>
- Date: Fri, 27 Jan 2012 14:35:53 -0600
I believe this will work
http://www.orafaq.com/usenet/comp.databases.oracle.server/2005/01/13/0713.htm
Glad those comp.databases.oracle.server archives are found in various places.
+1 Tom Kyte (heh)
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
"Quality is never an accident; it is always the result of intelligent effort."
-- John Ruskin (English Writer 1819-1900)
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and
may also be privileged. If you are not the named recipient, please notify the
sender immediately and delete the contents of this message without disclosing
the contents to anyone, using them for any purpose, or storing or copying the
information on any medium.
-----Original Message-----
From: Phil Jones [mailto:phil@xxxxxxxxxx]
Sent: Friday, January 27, 2012 2:29 PM
To: Taylor, Chris David
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Development question - Trigger to disallow UPDATE without WHERE
clause?
If v$sql gets populated before any records are actually processed (I imagine it
is, but a quick test will verify) & the sql_id in v$session also gets populated
after the query has been parsed but before any rows are processed you might be
able to do it in a before update trigger that throws an exception. You'll need
sys_context('USERENV','SID') to join with the v$ tables.
To be honest, you'd be better off using a cluebat on the devs :)
Phil
On 27 Jan 2012, at 20:13, "Taylor, Chris David"
<ChrisDavid.Taylor@xxxxxxxxxxxxxxx> wrote:
> Our developers are working on a large project that is going to require a lot
> of scripts to convert data and due to an error in one of the scripts one of
> our tables was fubar.
> So the question came up - is there a way in a trigger or other method to trap
> UPDATE statements that do not have a WHERE clause?
>
> I'm searching for this now but wanted to poll the list at the same time. Off
> the top of my head I couldn't come up with anything.
>
> Thanks!
>
> Chris
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
