[Q] SQL statements and bind variables.

Howdy, all...

Is there a way to see (possibly at run time) what is getting bound to the bind variables in a SQL statement?

For example, in v$sqlarea, a query shows up as this:

    SELECT A, B, C, D FROM TABLE WHERE A = :b1

When that statement is executed, is there a way to see what was bound to

b1?

Eric
--

Eric Ladner              | HPUX Systems Admin, Oracle DBA
Pascagoula Refinery      | Java Programmer, Perl scripter, C++
Chevron Products Company | programmer, etc., etc., etc.