OraFAQ Forum: SQL & PL/SQL » How to obtain the owner and name of a calling program

Home » SQL & PL/SQL » SQL & PL/SQL » How to obtain the owner and name of a calling program

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to obtain the owner and name of a calling program [message #38328]

Wed, 10 April 2002 15:40

Hugh
Messages: 7
Registered: April 2002

Junior Member

I have a general-purpose procedure which is locally called by many other procedures and functions on the same database. Is there a way to obtain the owner and name of the other procedures and functions from within the general-purpose procedure ?

I've tried everything including SYS_CONTEXT(), but I always received the logon id of the user.

You help is really appreciated.

Regards,

Hugh

Report message to a moderator

Re: How to obtain the owner and name of a calling program [message #38330 is a reply to message #38328]

Wed, 10 April 2002 16:13

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

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

Report message to a moderator

Previous Topic:	Optional parameters in oracle procs
Next Topic:	What is the difference?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 07:21:27 CDT 2024