Previously Undiscovered Oracle Gold

[DA Morgan]

Well at least to me.

I was looking around the OWA_UTIL package over the weekend and found
the WHO_CALLED_ME procedure.

It can be called in a stored procedure and returns the owner,
name, line number, and caller object type.

Could be a great addition to an error handling procedure.

There is a simple demo at www.psoug.org in Morgan's Library.

Daniel Morgan
www.psoug.org

[Michel Cadot]

"DA Morgan" <damo...@psoug.org> a écrit dans le message de news: 11465944...@jetspin.drizzle.com...

Is this not the procedure written by Tom Kyte years ago?

http://asktom.oracle.com/~tkyte/who_called_me/index.html

Regards
Michel Cadot

[steved...@gmail.com]

That is really useful. I wonder how you could walk your way back the
calling stack, and how large it can be?

Thanks!

Steve

[Mark C. Stock]

<steved...@gmail.com> wrote in message
news:1146598274.7...@u72g2000cwu.googlegroups.com...
: That is really useful. I wonder how you could walk your way back the

: calling stack, and how large it can be?
:
: Thanks!
:
: Steve

:

i seem to recall that there's a bug in the OWA_UTIL version of this (but i
may be recalling wrongly)

but the basics involve a call to 'dbms_utility.format_call_stack' and a bit
of parsing, per the link that cadot posted to tom kyte's sample

i use a custom package to for conditionally logging code execution that uses
this to record the name of the currently running procedure

++ mcs

[Brian Peasland]

I did not know about this one, but I can't say that it surprises me
either. The DBMS_DEBUG package can return the call stack from any proc
that you have stepped into. So the functionality has existed in one form
or another....

Cheers,
Brian

--
===================================================================

Brian Peasland
oracl...@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.

"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

[DA Morgan]

No. According to the header, PRIVUTIL.SQL, this has been around
since 1995 and was originally written by Bookman.

Rem mbookman 07/09/95 - Creation

Daniel Morgan
www.psoug.org

[thoma...@oracle.com]

DA Morgan wrote:
> Michel Cadot wrote:
> > "DA Morgan" <damo...@psoug.org> a écrit dans le message de news: 11465944...@jetspin.drizzle.com...

...

> > Is this not the procedure written by Tom Kyte years ago?
> >
> > http://asktom.oracle.com/~tkyte/who_called_me/index.html
>

> No. According to the header, PRIVUTIL.SQL, this has been around
> since 1995 and was originally written by Bookman.
>

Actually - this is my who_called_me and the cells print/list print/
calendar print among others is my original "owa_ext" (owa extensions)
package incorporated as well.

Not being in the development team - I just gave them the code ;)

mbookman created the owa_util package - but the subroutines inside were
added over a period of time.

[DA Morgan]

thoma...@oracle.com wrote:
> DA Morgan wrote:
>> Michel Cadot wrote:
>>> "DA Morgan" <damo...@psoug.org> a écrit dans le message de news: 11465944...@jetspin.drizzle.com...
> ...
>>> Is this not the procedure written by Tom Kyte years ago?
>>>
>>> http://asktom.oracle.com/~tkyte/who_called_me/index.html
>> No. According to the header, PRIVUTIL.SQL, this has been around
>> since 1995 and was originally written by Bookman.
>>
>
> Actually - this is my who_called_me and the cells print/list print/
> calendar print among others is my original "owa_ext" (owa extensions)
> package incorporated as well.
>
> Not being in the development team - I just gave them the code ;)

Thank you for the correction.

You really should start autographing your work. ;-)

This leads me to wonder what other treasures of yours lie
hidden there awaiting discovery.

Daniel Morgan
www.psoug.org