Re: Finding Out Bind Variable Values

From: Terry Dykstra <dontreply_tdykstra_at_cfol.ab.ca>
Date: Wed, 21 Nov 2001 19:04:14 GMT
Message-ID: <OUSK7.3226$c4.739842@news0.telusplanet.net>

dbms_system.set_ev(<sid>, <serial#>, 10046, <level>, '');

where <level> should be at least 4.

--
Terry Dykstra
Canadian Forest Oil Ltd.
"Buck Turgidson" <jc_va_at_hotmail.com> wrote in message
news:580389f07e50c4107cc8025a8bcf16ff.38849_at_mygate.mailgate.org...


> I can easily enough determine a currently running sql statement by

querying


> V$SQL_AREA/SESSION etc., but is there a way to find out the values of the

bind


> variables that the statement is currently using?

>

> This is version 8.1.6

>

> Thanks.

>

>

> --

> Posted from  [65.193.99.4]

> via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Wed Nov 21 2001 - 13:04:14 CST