Re: Getting SID in PL/SQL

HI

I think you can use USERENV('SESSIONID')

select userenv('sessionid') from dual;

Try this and let me know

Regards

N.Prabhakar

Thomas Keller wrote:

> Hi,
>
> I need a value that's unique at a time (but all values should be in the
> smallest possible range). My idea was to use the SID (for example from
> V$SESSION).
> Is it possible to get the Value from anywhere? When I try a SELECT from
> V$SESSION in a package I get an error when compiling the package...
>
> Any Ideas?
>
> Thomas Keller

Received on Fri May 07 1999 - 02:57:28 CDT