how to tell who the caller of a procedure is

From: Oxnard Montalvo <oxnard_at_carolina.rr.com>
Date: Wed, 30 Jan 2008 12:01:53 -0500
Message-ID: <4109765.122791201712513140.JavaMail.root@cdptpa-web13-z02>

Oracle ver 10.2.0.3.0

I have a procedure which is called from one of four functions. Other than simply passing the name in as a varchar is there a way to have the procedure known the name. In my procedure I have one of four things to do based on who the calling function is.

Thanks
Ox

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 30 2008 - 11:01:53 CST

This message: [ Message body ]
Next message: hrishy: "Re: TAF and node failover non RAC oracle 10.2"
Previous message: Jeremy Schneider: "Re: TAF and node failover non RAC oracle 10.2"
Next in thread: Mark W. Farnham: "RE: how to tell who the caller of a procedure is"
Reply: Mark W. Farnham: "RE: how to tell who the caller of a procedure is"
Reply: sol beach: "Re: how to tell who the caller of a procedure is"
Reply: Powell, Mark D: "RE: how to tell who the caller of a procedure is"
Reply: Mercadante, Thomas F (LABOR): "RE: how to tell who the caller of a procedure is"
Maybe reply: Nigel Thomas: "Fw: how to tell who the caller of a procedure is"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message