Skip to content


utPLSQL is an open-source testing framework for PL/SQL and SQL

It allow for automated testing of:

  • Packages
  • Functions
  • Procedures
  • Triggers
  • Views
  • Anything else that can be execute and observed from PL/SQL

utPLSQL is developed 100% voluntarily and embraces a Code of Conduct.

Feel free to try it out, you won't regret it. Additional information can be found in the documentation pages.

Version 3

While the framework exists since 1999, the current version 3 got completely rewritten in 2016 by passionate members of the community, using the object-oriented capabilities of the Oracle database to make it more consistent with other *Unit frameworks (e.g. JUnit for Java).

This had significant impact on the syntax and the way the framework can be used.


Major Active Maintainers

Name Comments
Jacek Gebal Project lead
Pavel Kaplya
Samuel Nitsche
Lukasz Wasylow
Philipp Salvisberg

Many thanks to all the contributors.

Major Contributors

Name Comments
Robert Love
David Pyke
Vinicius Avellar

Prior Major Contributors

Name Comments
Steven Feuerstein Original Author
Chris Rimmer
Patrick Barel
Paul Walker


The utPLSQL project is community-driven and is not commercially motivated. Nonetheless, donations and other contributions are always welcome, and are detailed below.

supported_by_redgate utPLSQL has been supported by Redgate in the form of sponsored stickers and t-shirts. Thank you for helping us spreading the word!

Last update: October 11, 2022 07:39:36
Created: June 20, 2016 21:37:31