-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Fri, Dec 07, 2001 at 01:33:23PM -0500, Kevin White wrote:
> Is there any way to get the Oracle session ID out of a $dbh, so I can
> log it and map it back?
SELECT SYS_CONTEXT('USERENV','SESSIONID') FROM DUAL;
This returns the current session's audit ID, which you can line up with the
audsid column in v$session.
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8
iQA/AwUBPBERwQOGqGs0PadnEQLpygCfdZb3n0ze5z1WHs9DcLr27JBmc2MAoIxX
zuDXvAQ0QsXiiE9eRNtezPZy
=rKvh
-----END PGP SIGNATURE-----
