test window problems on big packages

[Mss Steel]

Hi,
I'm experiencing a big problems with the test window of a procedure.

The workflow is: All objects, I open a package -> view spec and body. I receive the list of procedures. When I click with the right button to see "test", the window freeze.

It occours with packages with a lot of procedures. When I do it with a package who have about 10 procs, the problem down occours.

Anyone knows who can I fix it?

Thanks a lot

 

[ScottMattes]

Until the problem gets fixed, you can copy the function/procedure definition from the package spec and paste it into a Test Window manually. You will have to do some other things (like change the params used by the routine to have a ":" in front of their name and down in the grid where it says "Variable" you have to right click and select "Scan Variables" and then set your variable types). Tedious, but that will get you around the error while it is being worked on.

 

[Marco Kalter]

The workflow is: All objects, I open a package -> view spec and body. I receive the list of procedures. When I click with the right button to see "test", the window freeze.

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.