RE: How to find current value of bind variables

  • From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • To: "Ian Cary (C)" <Ian.Cary@xxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 2 Sep 2005 08:36:39 -0700

No, I hadn't seen that - it's exactly what I'm looking for but unfortunately 
that view seems to exist only in 10g and I'm working with 9i.  I'll look at the 
view definition though and see if it can be backported to 9i.
 
Thanks!
 

-----Original Message-----
From: Ian Cary (C) [mailto:Ian.Cary@xxxxxxxxxxxxxxxxxxxx]
Sent: Friday, September 02, 2005 4:40 AM
To: Allen, Brandon; oracle-l@xxxxxxxxxxxxx
Subject: RE: How to find current value of bind variables


Have you tried looking at 

v$sql_bind_capture

Cheers,

Ian



This email is only intended for the person to whom it is addressed and may 
contain confidential information. If you have received this email in error, 
please notify the sender and delete this email which must not be copied, 
distributed or disclosed to any other person.
Unless stated otherwise, the contents of this email are personal to the writer 
and do not represent the official view of Ordnance Survey. Nor can any contract 
be formed on Ordnance Survey's behalf via email. We reserve the right to 
monitor emails and attachments without prior notice.

Thank you for your cooperation.

Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000
http://www.ordnancesurvey.co.uk



Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.

Other related posts: