Home » SQL & PL/SQL » Client Tools » how to debug with 'pl sql developer tool' in effective way
how to debug with 'pl sql developer tool' in effective way [message #623402] Wed, 10 September 2014 00:16 Go to next message
mastansky@gmail.com
Messages: 13
Registered: July 2013
Location: INDIA
Junior Member

Hi,

Can anyone suggest me to Debug by using 'PLSQL DEVELOPER TOOL' in effective Way .


Thanks in Advance.
Re: how to debug with 'pl sql developer tool' in effective way [message #623409 is a reply to message #623402] Wed, 10 September 2014 02:31 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
This is a very broad question and you need to be specific. I see your post here too http://stackoverflow.com/questions/25757869/how-to-debug-with-pl-sql-developer-tool-in-effective-way and your question has been put on hold there.

Assuming that you are talking about the debug option provided in the TEST WINDOW of PL/SQL Developer client tool, I can tell you the basic steps :

For example, let's say you have a package, and you want to debug a procedure inside it.

1. Compile the package in your local.
2. Check whether the procedure is in the package specification, else, add it to the package specification.
3. Go to the object browser, find the respective package, right click and select view and edit.
4. It will open the package in a PL/SQL window.
5. Browse the left panel to see the procedure in the package specification, right click and select TEST.
6. It will open a test window and load the required package.procedure inside a BEGIN-END block.
7. Provide the required parameters in the test window.
8. On top, you would see the DEBUG option.
9. DO NOT click on EXECUTE button. Click the debugger button.
10. It will load the package.
11. Click STEP IN, which looks click a right turn sign.
12. It will let you debug line-by-line.
13. you can STEP OVER the lines you are not concerned.
14. Once you reach the line you want to test, select the variables that you want to see the values at run time.
15. You need to keep using the step in until you are done with debugging.
16. Once you reach END, the test window will execute the procedure.
17. If, point 15/16 fails, it means you got an error at that line number and you will automatically come out of the package.


Follow the above steps, and come back only if you have a specific question.

If you want to know further FAQs, you can have a look at PL/SQL Developer settings FAQ


Regards,
Lalit

[Updated on: Wed, 10 September 2014 02:34]

Report message to a moderator

icon14.gif  Re: how to debug with 'pl sql developer tool' in effective way [message #623454 is a reply to message #623409] Wed, 10 September 2014 06:09 Go to previous message
mastansky@gmail.com
Messages: 13
Registered: July 2013
Location: INDIA
Junior Member

Thanks Alot Buddy Smile Smile
Previous Topic: in the decode function & symbol not working and it is working as Bind Variable
Next Topic: Formatting the result set
Goto Forum:
  


Current Time: Fri Jan 19 16:38:04 CST 2018

Total time taken to generate the page: 0.05417 seconds