Re: how can a PL/SQL identify itself?

Am 20 Jan 2005 09:29:33 -0800 schrieb Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>:

> bidon70 (bidon70_at_hotmail.com) wrote:
> : Hello everybody,
>
> : I have browsed through the posts but I could not find any problem
> : similar to mine, so I would like to ask you this question:
> : is there a way to uniquely identify a running PL/SQL program (via the
> : V$ views, sys_context, etc.)?
> : I would like to get a unique identifier for a particular instance of a
> : program running and the identifier should be retrieved by the PL/SQL
> : itself.
> : I have tried with v$SESSION and V$PROCESS but it seems they do not
> : contain this kind of info.
>
> What is wrong with the session id?
>
> select userenv('sessionid') from dual ;

I think the OP likes to identify a special PL/SQL program (-module) rather than only the session context.
So he or she has to use DBMS_APPLICATION_INFO() to set module, action or client_info and than request the information by querying V$SQLAREA or calling DBMS_APPLICATION_INFO.READ_MODULE().

Regards

-- 
Frank Piron,
defrankatkonaddot
(leftrotate two)