How to find the values of bind variables through tracing?

From: Matt Larson <matt_larson_at_jdedwards.com>
Date: 1997/12/10
Message-ID: <66mstn$dku$1@server1.incc.net>#1/1

How to find the values of bind variables through tracing? I'm a DBA who occasionally is presented with a problem from our custom applications. I can trace the session with the
DBMS_SYSTEM.set_sql_trace_in_session(8,8,TRUE). But this only gives the sql statements with the bind varibles-- not the actual values.

Example: select :bind1, :bind2 from mytable where name=:bind3;

How do I show the actual values?

Example select col1, col2 from mytable where name='SMITH';

Please email answers to matt_larson_at_jdedwards.com

Thanks,
Matt Received on Wed Dec 10 1997 - 00:00:00 CST