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;)

At this present time there is now user-friendly interface for UTPSQL. However, this little query will show most of what you need to see in relation to this particular example…

select owner,name,executions,failures,last_status,last_end,last_run_id,last_status,name

from ut_package

where owner in ('MYSCHEMA');

On to Part 6[/szb]