
User Input: Enter the PL/SQL block, or enter NULL for no startup processing.įramework Activities: Execute the unit test.

User Input: Identify the object, such as a specific PL/SQL procedure or function.įramework Activities: Select the object for processing.

The steps are as follows, including the user input for before the step is run and the framework activities for the step while the test is being run. The SQL Developer unit testing framework involves a set of sequential steps for each test case. Section 3.12, "Example of Unit Testing (Tutorial)" Section 3.11, "Using the Command-Line Interface" Section 3.10, "Exporting and Importing Unit Test Objects" Section 3.7, "Using Variable Substitution in Validation Actions" Section 3.6, "Using Lookups to Simplify Unit Test Creation" Section 3.5, "Using a Dynamic Value Query for Seed Data" Section 3.4, "Editing and Running a Unit Test" Section 3.2, "SQL Developer User Interface for Unit Testing" This chapter contains the following major sections:

The unit testing feature is part of the support within the SQL Developer family of products for major parts of the life cycle of database system development, from design (provided by Data Modeler) to development to testing. The SQL Developer implementation of unit testing is modeled on the classic and well known xUnit collection of unit test frameworks. You create tests, and for each you provide information about what is to be tested and what result is expected. The SQL Developer unit testing feature provides a framework for testing PL/SQL objects, such as functions and procedures, and monitoring the results of such objects over time.
