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-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 ...

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