RE: how to tell who the caller of a procedure is

From: Mercadante, Thomas F (LABOR) <>
Date: Wed, 30 Jan 2008 12:07:28 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF019EF9E0@EXCNYSM0A1AJ.nysemail.nyenet>


Is the caller always the same Oracle user? If so, you can use dbms_application_info.set_action('INSERTING'); package in the calling procudure and then interrogate the context. But it would be easier to simply pass in the caller id.


-----Original Message-----

[] On Behalf Of Oxnard Montalvo Sent: Wednesday, January 30, 2008 12:02 PM To: Post to FreeList Oracle-L
Subject: how to tell who the caller of a procedure is

Oracle ver

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.


-- Received on Wed Jan 30 2008 - 11:07:28 CST

Original text of this message