Get the name of the calling procedure or function in Oracle PL/SQL

oracle function plsql procedure
Paul Yeoman picture Paul Yeoman · Sep 1, 2011 · Viewed 35.2k times · Source

Does anyone know whether it's possible for a PL/SQL procedure (an error-logging one in this case) to get the name of the function/procedure which called it?

Obviously I could pass the name in as a parameter, but it'd be nice to make a system call or something to get the info - it could just return null or something if it wasn't called from a procedure/function.

If there's no method for this that's fine - just curious if it's possible (searches yield nothing).

Answer

APC picture APC · Sep 1, 2011

There is a package called OWA_UTIL (which is not installed by default in older versions of the database). This has a method WHO_CALLED_ME() which returns the OWNER, OBJECT_NAME, LINE_NO and CALLER_TYPE. Note that if the caller is a packaged procedure it will return the PACKAGE name not the procedure name. In this case there is no way of getting the procedure name; this is because the procedure name can be overloaded, so it's not necessarily very useful.

Find out more.

Since 10gR2 there is also the $$PLSQL_UNIT special function; this will also return the OBJECT NAME (i.e. package not packaged procedure).

Related questions

PL/SQL: Retrieve names of procedures and functions within a package

Is it possible to retrieve the names of all procedures and functions that reside within a particular package? I understand that they can be gleaned (smells hack-ish) from the ALL_SOURCE view, but I would prefer a more canonical strategy.

Read More
PLS-00201 - identifier must be declared

I executed a PL/SQL script that created the following table TABLE_NAME VARCHAR2(30) := 'B2BOWNER.SSC_Page_Map'; I made an insert function for this table using arguments CREATE OR REPLACE FUNCTION F_SSC_Page_Map_Insert( p_page_…

Read More
Split function in oracle to comma separated values with automatic sequence

Need Split function which will take two parameters, string to split and delimiter to split the string and return a table with columns Id and Data.And how to call Split function which will return a table with columns Id …

Read More