Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: how to find the value of bind varaiable
From http://www.ixora.com.au/q+a/0103/28085837.htm, "V$SQL_BIND_DATA
gives you bind values for open cursors in the current session only".
So you have to
exec sys.dbms_system.set_ev(<SID>,<SERIAL#>,10046,12,'')
to get the bind variable values for another session. The values are in the udump trace file.
Somebody needs to add this to the FAQ.
Yong Huang
yong321_at_yahoo.com
postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0204230245.658d34d1_at_posting.google.com>...
> In 8i various v$ views exists. From the top of my head I only remember
> v$sql_bind_meta_data, but there are more, all with the word 'bind' in
> it.
> The dict view would typically contain all of them
Received on Tue Apr 23 2002 - 12:40:36 CDT