Commit 3bdd3c3

In the Connections window, select a connection or one or more packages or package procedures to run utPLSQL tests. Or you can run utPLSQL tests directly from the PL/SQL editor. The test procedures are determined according to the cursor position in the PL/SQL editor.

Select the tests to debug, the same way you would if you were just running them, but select `Debug utPLSQL test...` in the context menu.

And then the PL/SQL Debugger is called for the generated, anonymous PL/SQL block.

The initialization timeout for the realtime reporter is increased to 1 hour. The overall timeout is left to the default value of 4 hours. So you have enough time to step through the PL/SQL code and analyse it. Press the `Stop` button at any time to cancel the test run.

In the Connections window, select a connection or one or more packages for a code coverage report.

In the dialog you can set some parameters. If you run code coverage for a few chosen packages or from the PL/SQL editor the objects to be included are determined according the object dependencies in the Oracle data dictionary.

Press `Run` to produce the code coverage process in the background. You may minimize or close the dialog. To abort the process, press `Cancel`.

The HTML report is shown in your default browser.

Select a package, type, function or procedure to build a utPLSQL test package skeleton. The generated package compiles and executes, but still needs some rework.

1. Press the button `Create code templates` in the preferences

2. Type `ut_` in the Worksheet or a PL/SQL editor and press `Ctrl-Space` to get the list of a utPLSQL code templates

3. Press `Return` to paste a code template at the current cursor position

Annotations are used in the package specification for various test configurations.

Expectations are used in the package body to compare actual with expected results.

Set your preferences to change the behaviour of utPLSQL within SQL Developer.

utPLSQL can run tests based on suitepaths and suites. The next screenshot shows the generated run command for two selected suitepaths.

Use oddgen to generate utPLSQL test package skeletons. When generating to files, a file for each package specification and package body is created.