Daniel Morgan wrote:
> 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)
>
>
Would be nice, though - so I can finally migrate
from SQL Server's @@PROCID...
--
Regards, Frank van Bortel
Received on Sat Aug 16 2003 - 10:14:39 CDT
