utPLSQL is a unit testing framework for Oracle PL/SQL and SQL, following industry standards and best practices of modern testing frameworks like JUnit and RSpec.

• Multiple ways to compare data with matchers
• Native comparison of complex types (objects, collections, cursors)
• In-depth and consistent reporting of failures and errors
• Tests identified and configured by annotations
• Hierarchies of test suites configured with annotations
• Automatic (configurable) transaction control
• Built-in coverage reporting
• Integration with SonarQube, Coveralls, Jenkins and TeamCity via reporters
• Plugin architecture for reporters and matchers
• Flexible and simple test invocation
• Multi-format reporting from the command line client

• Oracle Database 19c or newer

Published releases are available for download on the utPLSQL GitHub Releases page.

To install utPLSQL into a new database schema and grant it to public, execute the script install_headless.sql. This creates a new user UT3, grants all required privileges, and creates PUBLIC synonyms.

For all install options see the Install Guide.

1. Write a test package

Annotate a package specification to define a test suite and its tests, then implement each test procedure in the package body:

2. Run your tests

3. See the results

For complete working examples see examples/.

From any Oracle-compatible IDE (SQL Developer, TOAD, PL/SQL Developer):

These commands run all suites in the current schema and report test results to DBMS_OUTPUT or as a result set.

utPLSQL-cli lets you run tests without an Oracle Client or IDE. It provides:

• Real-time test reporting
• Simultaneous output of multiple report formats into different files
• Source files and test files mapping for coverage reports

Download the latest release and see the CLI readme for details.

Full documentation is published at https://www.utplsql.org/utPLSQL/.

Cheat-sheets are available for quick reference.

See the Changelog for the full version history.

Migrating from legacy utPLSQL v2? See the version 2 to version 3 comparison.

We welcome contributions of all kinds. Please read the contributing guide and the code of conduct before getting started.

GitHub Discussions is the place to ask questions and connect with the team.

utPLSQL is community-driven and not commercially motivated. Donations and contributions are always welcome.

Authors