utPLSQL is a very versatile open source unit testing framework for Oracle PL/SQL.

It allow for automated testing of:

• Packages
• Functions
• Procedures
• Anything that can be execute or observed in PL/SQL such as:
  • Table Default Values
  • Table Triggers
  • View Triggers
  • Objects

utPLSQL was originally developed by Steven Feuerstein and is now maintained by active team of developers.

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