Re: The bind variables in a query

The answer depends on the Oracle version you are using.

For 9i and lower, tracing is the solution to capturing bind variables for an another session. For your session only, use view v$sql_bind_data.

For 10g, there is a new view V$SQL_BIND_CAPTURE which can be joined with V$SQLAREA to see all bind variables for any SQL.

Regards,
Tanya Received on Mon Nov 14 2005 - 14:39:34 CST