Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to get PLS/SQL package/procedure/function name ?

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

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 21 Dec 2004 08:51:49 +0100
Message-ID: <41c7d627$0$10109$636a15ce@news.free.fr>

"MarekD" <marekdull_at_poczta.onet.pl> a écrit dans le message de news:54c8df1c.0412202340.9bef499_at_posting.google.com...
| Hay,
| Is it possible to get current package/procedure/function name from
| inside of PL/SQL package/procedure/function ???
| Greetings, M.D.

Have a look at dbms_utility.format_call_stack function:

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_util2.htm#1002097

Regards
Michel Cadot Received on Tue Dec 21 2004 - 01:51:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US