Part 5: How to run a Unit Test
Search
Popular links
http://www.oracleapplicationexpress.com/
Part 5: How to run a Unit Test
In terms of Oracle Unit Tests and the use of UTPLSQL you could, if you wish, run the unit test from the command line on SQL*PLUS.
eg exec utplsql.test('P_TE_CUSTOMER'); (Note the absense of the preceeding 'UT_' when running the test, UTPLSQL is expecting you to just type the package name)
This will give you the result of your unit test in a text based output. (Remember to SET SERVEROUTPUT ON;)
This is ok for some applications but when you are developing code on a daily basis you may want a more "user-friendly" interface. Enter the excellent (and free) Ounit program by Steve Feuerstein. Ounit provides an easy to understand interface for you to run your unit tests in. Full details can be found at the site http://www.ounit.com/.