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.

Contributors

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  

Supporters

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!