Previous | Next
Topic: Getting utPLSQL to work under Unix
Conf: 537, Msg: 37911
From: Richard Li (richardl@arsdigita.com)
Date: 9/22/00 07:24 AM

Getting utPLSQL to work under Unix Richard Li richardl@arsdigita.com richardl@arsdigita.com Has anyone gotten utPLSQL to work under Oracle on Solaris? I've run into several things:

1. SSOO.SQL needs to be renamed to ssoo.sql since it's case sensitive.
2. plvvu.err is undefined.
3. grant create public synonym etc. permissions need to be granted to the db user.

Anyway, after granting the right permissions and renaming ssoo.sql, utPLSQL appears to load with errors about plvvu.err. I ignored those, and wrote a little bit of code. Now, I get:

SQL> exec utplsql.test('acs_object');
exec utplsql.test('acs_object');
Compile error: User-Defined Exception
Compile error: User-Defined Exception
Compile Error on:
BEGIN ut#acs_object.ut#new; END;
acs_object SUCCESS
tearing down!

Even though I have done:

exec utplsql.setdir('/web/richard/packages/acs-kernel/sql/');

to set things up. The code in question looks like:

procedure new
is
begin
dbms_output.put_line('calling new!');
utassert.eq (
'Creating a new test object',
acs_object.new(100, 'test_object'),
100
);
dbms_output.put_line('exiting new!');
end;

Any ideas as to what's going on? Thanks.