Previous | Next
Topic: Getting utPLSQL to work under Unix
Conf: 537, Msg: 37945
From: Richard Li (richardl@arsdigita.com)
Date: 9/22/00 01:36 PM

Getting utPLSQL to work under Unix Richard Li richardl@arsdigita.com richardl@arsdigita.com I renamed my files ut_acs_object.pks and ut_acs_object.pkb, removed my trailing slash, and renamed the package to be ut_acs_object. However, I get some ugly errors:

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

PL/SQL procedure successfully completed.

SQL> exec utplsql.test('acs_object');
exec utplsql.test('acs_object');
Compile error: User-Defined Exception
Compile error: User-Defined Exception
Compile Error "ORA-06550: line 1, column 7:
PLS-00201: identifier 'UT#ACS_OBJECT
.SETUP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored"
on:
BEGIN ut#acs_object.setup; END;
BEGIN utplsql.test('acs_object'); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'UT#ACS_OBJECT.SETUP' must be declared
ORA-06550: line 1, column 7:

I'm a little confused as to why the # still show up -- when did you update the version? Do you have it with anon checkout somewhere?

So, anyway, I renamed everything to # and split things out into appropriately named files. At this point, I get:

SQL> exec utplsql.test('acs_object');
exec utplsql.test('acs_object');
Compile error: User-Defined Exception
Compile error: User-Defined Exception
calling new!
Compile Error "ORA-02291: integrity constraint (RICHARD.ACS_OBJECTS_OBJECT_TYPE_
FK) violated - parent key not found" on:
BEGIN ut#acs_object.new; END;
SUCCESS: Package "acs_object"
tearing down!

Which is more or less what I expected (the constraint violation) except those pesky Compile errors still are there.

Also, the utGen.sql file in the utInstall directory (which is where I have been installing from; there appears to be identicaly code in the 1.1 directory) should be renamed to be all lower case (or the install file modified accordingly).