Re: Calling Procedure

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 25 May 2005 15:41:06 +0200
Message-ID: <d71v0r$4st$2@news1.zwoll1.ov.home.nl>

Björn Wächter wrote:
> Hi all,
> is there a way in oracle to get the name
> of the calling procedure?

More SQL Server habits?
The best way is define a variable within the procedure. You could try to work it out dynamically, see asktom.oracle.com - search for who_called_me. Is limited to 3 levels (package->procedure->function), could be reworked to make it level independent

-- 
Regards,
Frank van Bortel

Received on Wed May 25 2005 - 08:41:06 CDT