Home » SQL & PL/SQL » Client Tools » Debugging Problem In plsql Developer ver 7.0.0
Debugging Problem In plsql Developer ver 7.0.0 [message #245531] Mon, 18 June 2007 00:53 Go to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Dear All
I was unable to debug any program or script with plsql developer Version 7.0.0. I have studied from the provieded help That Test Window provides an integrated
debugger. To start a debug session, just press the Start button at the left of the debug toolbar instead of the Execute button in the main toolbar. The other buttons are now enabled and you are ready to debug.

But when i write the code in test window and try to debug but
the start button and other buttons are disabled.


Please tell me how can i debug the code. How can i enable the start and step into , step out buttons.

I will be very thankful to you.

Re: Debugging Problem In plsql Developer ver 7.0.0 [message #245863 is a reply to message #245531] Tue, 19 June 2007 01:52 Go to previous messageGo to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Still Waiting For Reply. Thanks
Re: Debugging Problem In plsql Developer ver 7.0.0 [message #245868 is a reply to message #245863] Tue, 19 June 2007 02:00 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Choose New-Test window.

This should look like this:
./fa/2617/0/



Indicated is the button to start the debugger.
Don't forget to set breakpoints, otherwise your code will run to completion.
  • Attachment: faq.PNG
    (Size: 19.13KB, Downloaded 8009 times)

[Updated on: Tue, 19 June 2007 02:01]

Report message to a moderator

Re: Debugging Problem In plsql Developer ver 7.0.0 [message #245904 is a reply to message #245531] Tue, 19 June 2007 03:48 Go to previous messageGo to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Dear Frank

I have tried to set the break point but enable to set breakpoin. When i click on the left margin it show the icon of the bookmark on the left side. But there is no icon for breakpoint. when i press the button as you mentioned it execute the whole program. It show output when i click on dbms_output tab.
Suppose I want to run simple loop and want to see the value of i variable on each repetation.

begin
for i in 1 .. 30 loop
dbms_output.put_line(i);
end loop;
end;

But can not debug it.
please tell me how to set the break point. the button start ,step into and stepout. how can i enable them.
thanks for reply.
Re: Debugging Problem In plsql Developer ver 7.0.0 [message #245923 is a reply to message #245904] Tue, 19 June 2007 05:39 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
to set a breakpoint, either click in the gutter (left margin, like you did, but now click slightly to the right of your bookmark), or right-click the gutter and select "set bookmark"
Re: Debugging Problem In plsql Developer ver 7.0.0 [message #245925 is a reply to message #245531] Tue, 19 June 2007 05:50 Go to previous messageGo to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Dear Frank
I have done as you say but Still i am unable to place breakpoint. It only places bookmarks. Please provide me detail of debugging. Or tell me what is the problem that it did not debug.

Thanks for reply.
Re: Debugging Problem In plsql Developer ver 7.0.0 [message #246012 is a reply to message #245925] Tue, 19 June 2007 10:13 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
What entries do you see in the pop-up menu when you right-click in the gutter?
Re: Debugging Problem In plsql Developer ver 7.0.0 [message #246106 is a reply to message #245531] Tue, 19 June 2007 23:40 Go to previous messageGo to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

It displays the following Entries in the popup window. But When i select set break point from the popup it did not set the breakpoint.

Attached file is as under.
./fa/2625/0/
  • Attachment: plsql.JPG
    (Size: 54.81KB, Downloaded 7858 times)

[Updated on: Tue, 19 June 2007 23:41]

Report message to a moderator

Re: Debugging Problem In plsql Developer ver 7.0.0 [message #246124 is a reply to message #246106] Wed, 20 June 2007 01:06 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Set the breakpoint in the actual code; in any existing stored program unit.
Setting breakpoints in the test-window seems to be impossible. (but does not make much sense either)
Re: Debugging Problem In plsql Developer ver 7.0.0 [message #246149 is a reply to message #245531] Wed, 20 June 2007 02:04 Go to previous messageGo to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

I can not understand your reply. Please explain debuggin process in detail with any example. That can clear the picture. I think that test window should debugg any code.

Thanks for reply.
Re: Debugging Problem In plsql Developer ver 7.0.0 [message #246207 is a reply to message #246149] Wed, 20 June 2007 05:16 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
The testwindow is used to call the code you want to debug.
Your production system consists of series of stored program units. It is these procedures, functions and packages that you want to debug.
You use the testwindow to set up/initialize your session to call the faulty code. Then you debug that code, not the code you use to setup your testcase.
Re: Debugging Problem In plsql Developer ver 7.0.0 [message #246216 is a reply to message #245531] Wed, 20 June 2007 05:36 Go to previous messageGo to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Dear Frank
I just want to learn the Debug process. Please Tell me the Debugg process in detail.
I try myself but failed. I will be very thankfull to you.
Re: Debugging Problem In plsql Developer ver 7.0.0 [message #246439 is a reply to message #246216] Thu, 21 June 2007 00:13 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Create stored procedure. Pretend this is the code containing the bug in your production environment. You want to find the bug, so you set a breakpoint in this stored procedure.
Then you need a way to call this procedure. For this you use the Test window. In this testwindow you prepare your variables and call the procedure.
Re: Debugging Problem In plsql Developer ver 7.0.0 [message #248067 is a reply to message #245531] Wed, 27 June 2007 23:38 Go to previous messageGo to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Still unable to debug the code. Has anyone provide help for debuggin process in plsql developer.

Thanks
Re: Debugging Problem In plsql Developer ver 7.0.0 [message #248096 is a reply to message #248067] Thu, 28 June 2007 01:15 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
ok. What code do you try to debug? Is it a stored procedure or the code you jotted down in the testwindow?
Re: Debugging Problem In plsql Developer ver 7.0.0 [message #248245 is a reply to message #245531] Thu, 28 June 2007 07:33 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
I'm not sure the how's and why's but sometimes when trying to debug in pl/sql developer I need to "add debug information" to the procedure I am trying to debug.

Right click on the procedure and choose add debug information.

I don't think this is the issue in your case as you are not even getting to the debugger, but worth a shot.

Re: Debugging Problem In plsql Developer ver 7.0.0 [message #248259 is a reply to message #248245] Thu, 28 June 2007 08:16 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Adding debug information to too many sources can lead to a "program too large" error on compilation of a random source.
Re: Debugging Problem In plsql Developer ver 7.0.0 [message #248675 is a reply to message #245531] Sat, 30 June 2007 05:20 Go to previous messageGo to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Dear

I got the point to debug the stored procedure or function. Now the debug ,stepinto and stepout buttons are also enabled. Now when i debugg the program it traverse the function on each statement. But i was not able to get the values of variables. I want to see the values of variable on each occuracne of variable.

Suppose I want to debug function Dis_sal.
./fa/2679/0/

Waiting for reply.
Thanks for previous reply
  • Attachment: 3.JPG
    (Size: 119.61KB, Downloaded 7772 times)

[Updated on: Sat, 30 June 2007 05:26]

Report message to a moderator

Re: Debugging Problem In plsql Developer ver 7.0.0 [message #248829 is a reply to message #248675] Mon, 02 July 2007 04:27 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Hover your mouse over it../fa/2683/0/
  • Attachment: faq.png
    (Size: 7.76KB, Downloaded 7466 times)
Previous Topic: about stred procedure
Next Topic: ORA :12170 : TNS Connect Timeout Occurred
Goto Forum:
  


Current Time: Sun Dec 04 02:39:59 CST 2016

Total time taken to generate the page: 0.08089 seconds