Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Q: how to find the value of bind varaiable

Re: Q: how to find the value of bind varaiable

From: Yong Huang <yong321_at_yahoo.com>
Date: 23 Apr 2002 10:40:36 -0700
Message-ID: <b3cb12d6.0204230940.7e58895b@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US