|
Hi!
Search for dbms_utility.format_call_stack on
asktom.oracle.com, there are some examples how to check who has executed
"me".
But this gets to kind of hacking... so you should
first search for other solutions..
Tanel.
----- Original Message -----
Sent: Wednesday, July 30, 2003 10:14
PM
Subject: Re: ** table triggers
Thanks Jay and Gogala for your help : Well these are old big tables
and any re-design will be a bigger impact.
. YEs i agreed the trigger will fire no matter what. What I am looking
for is a check in the beginning of the trigger and then skip the rest of the
trigger. Thank You
It
sounds like this column belongs in a table that is the parent of tables A
and B.
>>> [EMAIL PROTECTED] 07/30/03 02:09PM
>>>
You can't. An update statement is what fires the trigger.
Trigger cannot
see where does the statement come from. May be you should
rethink the overall
design of the application?
On 2003.07.30
13:59, A Joshi wrote:
> Hi,
> I have a two tables A and B. Both
have a field expected_delay_now and when
> it gets updated by a user
in either table I want update it in corresponding
> row in the other
table. However when this update is as a result of a trigger
> (and not
user updated) how do I skip the update thru the trigger??? Thanks
>
>
>
>
>
---------------------------------
> Do you Yahoo!?
> Yahoo!
SiteBuilder - Free, easy-to-use web site! design software
--
Mladen Gogala
Oracle DBA
**DISCLAIMER
This
e-mail message and any files transmitted with it are intended for the use of
the individual or entity to which they are addressed and may contain
information that is privileged, proprietary and confidential. If you are not
the intended recipient, you may not use, copy or disclose to anyone the
message or any information contained in the message. If you have received
this communication in error, please notify the sender and delete this e-mail
message. The contents do not represent the opinion of D&E except to the
extent that it relates to their official business.
--
Please see the
official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jay
Hostetter
INET: [EMAIL PROTECTED]
Fat City Network
Services -- 858-538-5051 http://www.fatcity.com
San Diego, California --
Mailing list and web hosting
services
---------------------------------------------------------------------
To
REMOVE yourself from this mailing list, send an E-Mail message
to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the
message BODY, include a line containing: UNSUB ORACLE-L
(or the name of
mailing list you want to be removed from). You may
also send the HELP
command for other information (like subscribing).
Do you Yahoo!?
Yahoo!
SiteBuilder - Free, easy-to-use web site design
software
|
