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
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
From http://utplsql.sourceforge.net/Doc/fourstep.html
It looks rather simple, but you must connect to sqlplus 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