Debugger Does Not Work

[Maggie]

Can you please help.

I create and compile a .sql script succesfully.

I right-click and change to "Test Window".

I cannot create any breakpoints.

Here are the elements that define my environment.

PL/SQL Developer Version 9.0.0.1601
Operating System: Ubuntu
Server: Linnux
Oracle 11g
Windows 7 Professional 64 bit

 

[mike]

You aren't creating a test script correctly. Chapter 5 of the User's Guide does a good job explaining how to do it.

The test script is basically an anonymous block to call your compiled code. So, don't have your code be the test script in the test window.

Briefly how to do it is:
1. Compile your code with debug information. One way is to right click a package/procedure/function in the object browser and select "Add Debug Information. It will be in the recent objects folder if you recently compiled it.

2. Create a test script. One easy way to do it is to right click on a public procedure/function of a package in the code contents and select "Test" (with it open in a package window, NOT script window). For standalone procedures and functions, right click on the function or procedure in the object browser and select "Test". It will make a script for you.

3. If your code is open in the package window, you can put breakpoints there. You can also step through your test script until it opens the package you are testing and you can put breakpoints there.

The User's guide has pictures and everything so it will be easier to understand. Hopefully this gives you a brief idea though.

 

[Babo]

Maggie,
offtopic question - how do you run PLD on linux ?

 

[Maggie]

we use Wine and a Virtual NoMachine A.K.A. !M NX

 

[Babo]

thank you Maggie.

 

[Maggie]

Wow,thanks, Mike, I'll give that a try.