DBAsupport.com 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  c.name                      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, c.name 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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.