17-2. Installing the utPLSQL Unit Testing Framework
Problem
You've chosen the utPLSQL
unit-testing framework for PL/SQL for your work, and you want to install it.
Solution
First, download the utPLSQL
sources from http://utplsql.sourceforge.net/
. Once you have obtained the sources, use the following steps to install the utPLSQL
package into the database for which you wish to write unit tests, and make it available for all schemas.
Create a user to host the
utPLSQL
tables, packages, and other objects. In this example, the user will be namedUTP
, and the default permanent and temporary tablespaces will be used.
SQL> create user utp identified by abc123;
Grant privileges to the newly created
UTP
user using theGRANT privilege_name TO user_name ...
Get Oracle and PL/SQL Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.