From oracle-l-bounce@freelists.org Fri Sep 2 10:37:12 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j82FbB1v010307 for ; Fri, 2 Sep 2005 10:37:11 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j82Fb5IP010272 for ; Fri, 2 Sep 2005 10:37:05 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 54F711E93DA; Fri, 2 Sep 2005 10:36:58 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25210-01; Fri, 2 Sep 2005 10:36:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BF3031E93D0; Fri, 2 Sep 2005 10:36:57 -0500 (EST) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.326 Priority: normal Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5AFD4.1C979A68" Subject: RE: How to find current value of bind variables Date: Fri, 2 Sep 2005 08:36:39 -0700 Message-ID: <04DDF147ED3A0D42B48A48A18D574C4502361526@NT15.oneneck.corp> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How to find current value of bind variables thread-index: AcWvFIBjTTKeEW14Q9KAlgTEpMyAMgAnmqogAAhBmqA= From: "Allen, Brandon" To: "Ian Cary (C)" , X-archive-position: 24954 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Brandon.Allen@OneNeck.com Precedence: normal Reply-To: Brandon.Allen@OneNeck.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.7 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5AFD4.1C979A68 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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. =20 Thanks! =20 -----Original Message----- From: Ian Cary (C) [mailto:Ian.Cary@ordnancesurvey.co.uk] Sent: Friday, September 02, 2005 4:40 AM To: Allen, Brandon; oracle-l@freelists.org Subject: RE: How to find current value of bind variables Have you tried looking at=20 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. ------_=_NextPart_001_01C5AFD4.1C979A68 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
No, I=20 hadn't seen that - it's exactly what I'm looking for but unfortunately = that view=20 seems to exist only in 10g and I'm working with 9i.  I'll look at = the view=20 definition though and see if it can be backported to = 9i.
 
Thanks!
 
-----Original Message-----
From: Ian Cary (C)=20 [mailto:Ian.Cary@ordnancesurvey.co.uk]
Sent: Friday, = September 02,=20 2005 4:40 AM
To: Allen, Brandon;=20 oracle-l@freelists.org
Subject: RE: How to find current = value of=20 bind variables

Have = you tried=20 looking at

v$sql_bind_capture

Cheers,

Ian



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

Thank you for your cooperation.

Ordnance=20 Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079=20 = 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.

------_=_NextPart_001_01C5AFD4.1C979A68-- -- http://www.freelists.org/webpage/oracle-l