Re: Finding Out Bind Variable Values

Way 1) If the code is running in your own session,

1)sqlplus > select * from v$sql_bind_data.

Way 2) For queries in other sessions, find that sessions sid and serial# from v$session and then

sqlplus > exec dbms_system.set_ev(sid,serial#,10046,4,'');

--
Posted via dBforums
http://dbforums.com