17-8. Reconfiguring utPLSQL Parameters

Problem

You would like to change some of the configurations for your utPLSQL install. For instance, you would like to change the prefix for all of your unit test packages so that, instead of beginning with ut_, they all start with test_.

Solution

Use the utConfig package to alter the configurations for utPLSQL. For this solution, you will see how utConfig can be used to change the prefix that is used for all of your test packages. For example, here's how to change the prefix for your test packages from ut_ to test_ using the utConfig package for the current schema.

SQL> exec utConfig.setPrefix('test_'); PL/SQL procedure successfully completed.

After executing the statement in the example, the utPLSQL ...

Get Oracle and PL/SQL Recipes: A Problem-Solution Approach now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.