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 09:08:33 +0100
Message-ID: <41c7da11$0$10122$636a15ce@news.free.fr>

"Michel Cadot" <micadot{at}altern{dot}org> a écrit dans le message de news:41c7d627$0$10109$636a15ce_at_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
|

Have also a look at an example on Tom Kyte site at: http://osi.oracle.com/~tkyte/who_called_me/index.html

Regards
Michel Cadot Received on Tue Dec 21 2004 - 02:08:33 CST

Original text of this message

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