How to find the value of Bind Variable
Hi to All,
I have a small front end application, where I dont have a source code for it. We are migrating that application. I am able to found out what are all the queries used by the application through the
enabling the SQL Trace to that session. But I need to see the bind variables to be viewed.
I tired through the v$sql_bind_capture query but I am getting the bind variables only for the last executed query in a report.
I turned on the 10046 trace event but trace file does not get generated on the UDUMP directory. How to find out the value of the bind variable. can you people suggest me the ways to get the value of the bind variables.
Regards,
Vijayaraghavan K