PL/Unit

PL/Unit is a unit testing framework that I wrote sometime back in the early 2000's for Oracle's PL/SQL language. It's very lightweight, just one package in the database, and very reminiscent of junit. I had used it for years, and it is very stable. Originally, it was written as an integrated piece to Apollo Pro, the Oracle query tool that I wrote back in 1998. I have since released just the package for people to use, as it does have a command line test runner as well.

The package source was closed, as I had not ported the unit tests over from Delphi's unit test framework into PL/SQL, and so I didn't want untested versions of the package floating around the net. I'd love to make the time to port the tests and open source it, but alas, I seem to have too many things on my todo list and not enough time!

I have stopped maintaining this package a long time ago now, so your mileage may vary on it's use in the latest versions of Oracle. I believe it was functioning properly in 11g, the last version I personally tested. I had hosted it on a now defunct VCS. If I can ever find the source code backups I'll post it up.

http://plunit.timbert.net/ - get the package. Includes an online tutorial.