Re: accessing (packaged) procedure name within procedure

Comments interspersed.

Jetlag wrote:

> Linux, Oracle 9.2.0.1
>
> Does anyone know of a system variable or some kind of logic which
> would return a string containing the name of the currently executing
> procedure?

It can not be done nor does it make any sense unless you are assuming an Oracle database with a single connected user.

> .MY_PAK
> 0x55dafac8 1 anonymous block
>
> Suggestions would be most welcome. Thanks.
>
> -- jetlag --

Take a look at:

v_$sga
v_$open_cursors
v_$sql_area
v_$sessions

They may be of some help.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)