Re: object name

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 27 Oct 2004 19:02:29 -0700
Message-ID: <1098928890.308241@yasure>

dbyy wrote:

> "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in
> news:q9WdnY4YnawjbuPcRVn-pw_at_comcast.com:
>
>

>>"dbyy" <noname_at_fooled.com> wrote in message
>>news:Xns958ECC5FA550Edbyyatcanadadotcomni_at_207.35.177.135...
>>| hi everyone,
>>|
>>| it might sound like a silly questions.
>>|
>>| I have a trigger with a name like BEF_TBL_INS_ROW.
>>| In the exception section, I would like to insert a row in a log_table
>>| with some details about the trigger/exception.
>>| One thing is that I would like to store the name of the trigger (as
>>| current module) in the log_table.
>>| Is there a system variable or a func_call which returns the name of 

>
> the
>

>>| current module ('BEF_TBL_INS_ROW').
>>| I know I could use the name of the trigger as literal in the insert
>>| statement. But I would prefer to use a system_var or func call (if
>>| available).
>>|
>>| I wonder whether someone has a solution for me.
>>| Any help much appreciated.
>>|
>>| Thanks in advance.
>>| Fred
>>|
>>
>>i was just reviewing an old post on this same subject ... tom kyte has 

>
> an
>

>>example called 'who_called_me' and 'whoami' that use the
>>dbms_utility.format_call_stack package procedure to determine the name 

>
> of
>

>>the calling and current procedure.
>>
>>who_called_me was rolled into the owa_util package of the pl/sql web
>>toolkit, but does not work reliably in earlier versions of the toolkit
>>
>>see http://asktom.oracle.com/~tkyte/who_called_me/index.html
>>
>>++ mcs
>>
>>

>
>
> Hi Mark,
>
> Thanks for your quick answer.
> (strange.... two posting of mine and each answer came from 'Mark') ;-)
>
> Thanks for your tip.
> Fred

Hey Mark ... quit making the rest of us look bad. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Wed Oct 27 2004 - 21:02:29 CDT