PL/SQL Developer - The Test Manager

Screenshot

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).

Screenshot

back