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

From: Tanel Põder <tanel.poder.003@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Sat, 28 Feb 2004 18:44:21 +0200

Check v$sql_bind_data view.

Tanel.

  ----- Original Message ----- 
  From: Ryan 
  To: oracle-l@xxxxxxxxxxxxx 
  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:
      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?

References:

anyway to get binds out of the data dictionary?
From: Ryan

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

Other related posts: