Pl/SQL tracing Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Pl/SQL tracing

  1. #1
    Join Date
    Jul 2011

    Pl/SQL tracing

    I'm asking about how to go about, too see the contents of variables that are going into a very simple pl/sql procedure, they are all IN variables.

    I'm calling in from a c# program, through a provider to call an simple update procedure, but it's not working. I suspect the provider of being buggy.

    I want to see
    1. If it being called at all.
    2. What parameters are being offered to it.

    I have the session Id, and the sql Id from 'pl/sql developer' but the actual call only shows the usual UPDATE BETA_AUTO SET RULEGUID = :B4 , NAME = :B3 etc.

    How would I go about showing what B4,B3,B2,B1 is?


  2. #2
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    If properly setup no trace is needed.

    Use query below plugging in hash_value...
    select                      BIND, 
            substr(c.value_string,1,25) VAL
    from    v$sqlarea a, 
            v$sql_bind_capture c
    where   a.sql_id = c.sql_id 
    and     a.hash_value = 'hash_value'
    order by a.last_active_time desc, asc
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Jul 2011
    Pablo Berzukov
    I will give it a try.

  4. #4
    Join Date
    Jul 2011
    Pablo Berzukov
    That worked perfectly.
    It showed that the bltoolkit odp provider isn't passing values properly into sp's.

Tags for this Thread

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