Re: How to get PLS/SQL package/procedure/function name ?

From: Pete Finnigan <plsql_at_petefinnigan.com>
Date: Tue, 21 Dec 2004 09:13:31 +0000
Message-ID: <NQpzciA7k+xBRx+Y@peterfinnigan.demon.co.uk>

In article <54c8df1c.0412202340.9bef499_at_posting.google.com>, MarekD <marekdull_at_poczta.onet.pl> writes
>Hay,
>Is it possible to get current package/procedure/function name from
>inside of PL/SQL package/procedure/function ???
>Greetings, M.D.

Hi,

try the DBMS_UTILITY.FORMAT_CALL_STACK package procedure. There are two handy functions, who_called_me and who_am_i from Tom on his site at http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:15294 05950004

beware of the URL wrapping.

kind regards

Pete

-- 
Pete Finnigan (email:pete_at_petefinnigan.com)
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

Received on Tue Dec 21 2004 - 03:13:31 CST