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
Leave a Reply