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

Thread: Pl/SQL tracing

  1. #1
    Join Date
    Jul 2011
    Posts
    3

    Pl/SQL tracing

    Hi,
    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?

    Bob

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

    Use query below plugging in hash_value...
    Code:
    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
    Posts
    3
    Pablo Berzukov
    I will give it a try.
    Bob

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

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