Oracle and PL/SQL Recipes: A Problem-Solution Approach

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 named UTP, 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 the GRANT privilege_name TO user_name ...