I am trying to track down a bind variable in Oracle 8i and 9i. I've heard that this can be done. Is there anyone out there who has successfully done this?
If so, could you supply the detail information on the approach.
Printable View
I am trying to track down a bind variable in Oracle 8i and 9i. I've heard that this can be done. Is there anyone out there who has successfully done this?
If so, could you supply the detail information on the approach.
You have to set the 10046 event. You can do this by either issuing
if you can alter the session.Code:alter session set events '10046 trace name context forever, level 4'
Otherwise, as system, you can
(where sid, serial# are from v$session of the session you want to trace)Code:exec sys.dbms_system.set_ev(sid, serial#, 10046,4,'');
as a dba to enable tracing in an existing session.
THANKS !!!!
Hi Jeff
After executing the procedure how to check the value?
My serveroutput is on. But still it is not displaying any value.
Pls. guide me
Regards
Look for the file generated in the user_dump_dest
Cheers
Angel