O'Reilly logo

Oracle and PL/SQL Recipes: A Problem-Solution Approach by Matt Arena, Josh Juneau

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

17-7. Running a utPLSQL Test Suite

Problem

You have defined a test suite and now wish to run the tests.

Solution

Use the utPLSQL.testSuite routine to run your tests. For example, here's how run the test suite defined in Recipe 17-6.

exec utPLSQL.testSuite ('My Test Suite', recompile_in=>false);

Executing the above test suite produces the following results.

SQL> exec utPLSQL.testSuite ('My Test Suite', recompile_in=>false); . >    SSSS   U     U   CCC     CCC   EEEEEEE   SSSS     SSSS >   S    S  U     U  C   C   C   C  E        S    S   S    S >  S        U     U C     C C     C E       S        S >   S       U     U C       C       E        S        S >    SSSS   U     U C       C       EEEE      SSSS     SSSS >        S  U     U ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required