Re: anyway to get binds out of the data dictionary?

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Sat, 28 Feb 2004 18:44:21 +0200
Message-ID: <2a6e01c3fe1a$1fbd2480$73f823d5@porgand>

Check v$sql_bind_data view.

Tanel.

• Original Message ----- From: Ryan To: oracle-l_at_freelists.org Sent: Saturday, February 28, 2004 6:26 PM Subject: anyway to get binds out of the data dictionary?

  I'm not happy with the error logging that our software engineers are doing I want to do the following:

1. Use an on error database trigger
2. When an error occurs insert to a table the following:
3. sid
4. user (we are using connection pooling so this has limited use)
5. last sql statement
6. timestamp

  We are using bind variables. Anyway to grab what the actual values are?

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Sat Feb 28 2004 - 10:41:24 CST