Re: How to capture Session ID?

Hi there...

Try the following:

select userenv('SESSIONID') from dual;

This should give you the sessionid. I've used userenv('SESSIONID') in PL/SQL myself and it works just fine.

Regards
$Oyvind

jane604_at_my-deja.com wrote in message <7o9jnb$f5d$1_at_nnrp1.deja.com>...
>Does anyone know how to capture the sessionid from Oracle? Is there
>any way to use PL/SQL?
>Someone suggested to me to try termenv, but I can't find any
>documentation on it.
>Thanks!!!!
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Aug 04 1999 - 11:25:25 CDT