How do I see bind variable in Oracle?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How do I see bind variable in Oracle?

  1. #1
    Join Date
    Jun 2000
    Posts
    117

    Question

    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.


    E. Yen
    OCP DBA 8, 8i, 9i

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You have to set the 10046 event. You can do this by either issuing
    Code:
    alter session set events '10046 trace name context forever, level 4'
    if you can alter the session.

    Otherwise, as system, you can
    Code:
    exec sys.dbms_system.set_ev(sid, serial#, 10046,4,'');
    (where sid, serial# are from v$session of the session you want to trace)
    as a dba to enable tracing in an existing session.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2000
    Posts
    117

    Exclamation

    THANKS !!!!
    E. Yen
    OCP DBA 8, 8i, 9i

  4. #4
    Join Date
    May 2002
    Posts
    163
    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
    Nwcomer
    Student

  5. #5
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Look for the file generated in the user_dump_dest

    Cheers

    Angel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width