2

I am trying to setup utPLSQL for writing a unit test for PLSQL project. I am running into error while installing. I am not getting how to install it. Could anyone give a step by step procedure to install utPLSQL ?

Thanks

APC
  • 144,005
  • 19
  • 170
  • 281
Priyanka
  • 67
  • 6

1 Answers1

1

From http://utplsql.sourceforge.net/Doc/fourstep.html

It looks rather simple, but you must connect to as SYSTEM - a power user on your database that will be able to create the UTP user.

SQL> connect system/< the system's password >

SQL> create user utp identified by utp default tablespace
       users temporary tablespace temp;

SQL> grant create session, create table, create procedure,
      create sequence, create view, create public synonym, drop public synonym to utp;

SQL> alter user utp quota unlimited on users;

Then only run

SQL> ut_i_do install 
J. Chomel
  • 8,193
  • 15
  • 41
  • 69
  • ut_i_do install is not found. SQL> ut_i_do_install SP2-0734: unknown command beginning "ut_i_do_in..." - rest of line ignored. – kame Mar 25 '20 at 09:57