Calling Procedure

From: Björn Wächter <Bjoern.Waechter_at_p3-solutions.de>
Date: Wed, 25 May 2005 15:14:16 +0200
Message-ID: <3fjc1eF78f6dU1@news.dfncis.de>

Hi all,
is there a way in oracle to get the name of the calling procedure?

Example:

---

PROCEDURE Sp_AAAAA
AS
BEGIN     dbms_output.put_line('Called by: ' || ?????????? );

END Sp_AAAAA;

---

PROCEDURE Sp_BBBB
AS
BEGIN     Sp_AAAAA;

END Sp_BBBB;

---

Output:

Called by: Sp_BBBB

Thanks Björn

-- 
-------------------------------------
Dipl.-Ing. Björn Wächter
P3 Solutions GmbH
Dennewartstr. 25-27
D-52068 Aachen
Germany
http://www.p3-solutions.com

tel +49(0)241/9437-417
fax +49(0)241/9437-431

Received on Wed May 25 2005 - 08:14:16 CDT