This content has been marked as final. Show 1 reply
If you're using PL/SQL Developer, then check the help file.
You can test your package using a test window and/or the debugger that comes along with PL/SQL Developer..
How it works is explained in the help file.
It is important that before you start debugging, you have several test scenario's written out, containing the various inputs and expected outputs, based on the business rules that apply per case.
Also it doesn't hurt to read about 'instrumentation code', in order to see how your package executes.
You can search on http://asktom.oracle.com to find out more, using such an approach.
Here's an introduction:
And while we're at it, and you're new to Oracle, you might want to read:
And if you mean SQL Developer (free, from Oracle) instead of PL/SQL Developer (not free, from Allround Automations)
then check out the SQL Developer forum @ SQL Developer
Edited by: Hoek on Nov 18, 2012 11:10 AM