I'm currently looking for an Oracle unit testing framework - OUnit seems to be mentioned a lot however the website seems to be MIA.
Is there something else I should be looking for?
asked
Oracle unit testing frameworks?
PL/SQL Developer by Allround Automations used to have a Unit Testing feature. It wasn't overly advanced but it may be of use to you.
The new version of Oracle SQL Developer (2.1) has some unit testing features.
http://www.oracle.com/technology/obe/11gr2_db_prod/appdev/sqldev/sqldev_unit_test/sqldev_unit_test_otn.htm appears to be the closest to an official page about what that actually means.
I developed a basic unit testing framework based on the old work from Steven Feuerstein, which he eventually developed into Quest's product. It's fairly basic, but functional and free.
Advantage over Feuerstein's original work: it's simple to install and use.
http://stewstools.wordpress.com/2009/09/29/plsql-unit-testing-package/
Separately, Mark Y said the Quest product is in beta, but it's been out for commercial release for over a year. They're just developing an upgrade and releasing to Beta. They're more than happy to have you pay $$$ for the production release. I've checked out the 1.0 release and, while it did a very thorough job of testing all kinds of things, I found cumbersome, unintuitive and error-prone. I'm sure Steven has improved it since then, though I haven't seen it.
Update: oakesgr - Excellent thought to point out PL/SQL Developer's feature, which I didn't think to mention. I've used it, though I find it cumbersome to set up so many test scripts, so use my solution above instead.
Quest Code Tester for Oracle is up to version 1.8.5, about 10 releases newer than v1 that came out almost 3 years ago. It's a lot easier to get started on it than what it was then. It's more complicated than any of the other frameworks for one very simple reason - it actually generates the test code for you. So rather instead of just providing a repository and framework, in Code Tester you describe your outcomes and it generates the test code. It has built-in support for testing queries, tables, collections, refcursors, exceptions, expressions, XML, files, etc. There is also a freeware
I have created and using PL/SQL unit testing framework using Ruby library ruby-plsql.
It provides much shorter and more readable tests than utPLSQL and gives more flexibility compared to GUI tools (like Quest Code Tester or SQLDeveloper 2.1).
