views:

129

answers:

3

Does anyone have any frameworks/apps/methodologies for creating Unit tests with Oracle?. I'm using Oracle 11g.

I also have Team Foundation Server installed, where we do all our other development work with Visual Studio on a web app.

Edit: I'm looking to run unit tests on Packages, Procedures and Functions within Oracle (PL/SQL)

+3  A: 

There are two mature frameworks for unit testing PL/SQL, both originating from Steven Feuerstein. The older framework is utplsql. This is pure PL/SQL. It is pretty good, but it is no longer actively maintained. It's FOSS though.

Steven's more recent efforts have been directed towards Quest Code Tester for Oracle. This comes with a GUI and all sorts of bells'n'whistles. It is Windows only (but I suspect that won't bother you). Also it is licensed rather than free (there used to be a free edition but that doesn't appear to still be the case).

APC
+1  A: 

The new sql developer release (2.1) has support for unit testing: http://www.oracle.com/technology/products/database/sql%5Fdeveloper/files/relnotes%5Fv2.1.html

tuinstoel