To perform regression testing for your Oracle stored program units you can use
the Test Manager. It allows you to define a Test Set, which is a collection of
Test Scripts with input variable values and required output. After running a
Test Set, you can quickly see if all tests were successful, and if not, which
tests have failed. In the example above, the test with name "DeptName(7499)"
failed, because the output variable "result" did not have the required value.
Each test corresponds to a Test Script as used by the debugger, so that you can quickly launch the debugger in case of an error. Errors can be caused by unexpected output variables, unexpected dbms_output, Oracle exceptions, or performance (elapsed time).