anyway to get binds out of the data dictionary?

  • From: "Ryan" <ryan.gaffuri@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 28 Feb 2004 11:26:03 -0500

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:
    a. sid
    b. user (we are using connection pooling so this has limited use)
    c. last sql statement
    d. timestamp

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

Other related posts: