DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: PL/SQL Developer Problem

  1. #1
    Join Date
    Apr 2008
    Location
    Bhubaneswar,Orissa
    Posts
    2

    PL/SQL Developer Problem

    Hi

    I am using plsql developer,I know there is a debug step by step execution buttion for step by step execution.
    But it is in disabled state in my tool,When i clicked on it for the first time the error message was --insufficient priviledges.
    Now it always stays in disable state..

    Kindly help.
    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    While I have never used pl/sql developer, Doesn't debugging a stored procedures rely on compiling stored procedures with debug?

  3. #3
    Join Date
    Apr 2008
    Location
    Bhubaneswar,Orissa
    Posts
    2

    Execution wrt plsql developer

    No,I don't think so.For compilation there is separate option in this tool
    for execution there are two options
    1- normal way execute ditrectly like exec procedure_name or press the execute button
    2-To press the debug execute button which will take you inside the proc and show values in each step.

    If anyone know how to enable it,please let me know.Thanks

  4. #4
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    As far as I know, it is not possible to debug a PL/SQL package in normal compiled mode. It has to be compiled in INTERPRETED mode to be debugged. My *guess* is that PL/SQL developer is doing this for you behind the scenes. My further guess is that it is trying to do this as the user you are connecting with. It is either trying to ALTER PACKAGE x COMPILE DEBUG or it is trying to do an ALTER SESSION/SYSTEM to set PLSQL_DEBUG to true. In either case, I'm guessing that your user simply does not have the proper grants to be able to do that.
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

  5. #5
    Join Date
    Apr 2008
    Location
    Brazil
    Posts
    3
    to execute the procedure_name, press the left button of mouse.
    click in the 'test',
    down you can pass the parameters and press F9 to start the debugger
    to execute step by setp press (ctrl-n) "step into"

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