anyway to get binds out of the data dictionary?

From: Ryan <ryan.gaffuri_at_cox.net>
Date: Sat, 28 Feb 2004 11:26:03 -0500
Message-ID: <032701c3fe17$8f192ac0$51a36244@ryan2le36ofjce>

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:20:49 CST