How to Debug Package

[ladonna]

How do you debug a package?

I have a package that calls a procedure and returns a REF CURSOR. How do I debug this? Also, how do you debug any package?

 

[Marco Kalter]

You can select the package in the Object Browser, expand the Procedures or Functions folder and select your procedure that returns a cursor. Right-click on it, and select "Test" from the popup menu.

Now you can set values for the parameters, and execute Test Window in normal or debug mode. After execution, you can view the cursor result set by pressing the cell button for the cursor variable value.

------------------
Marco Kalter
Allround Automations