Here's what I think is happening:

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

The two compile error exceptions mean that the test package has not been recompiled. Unless you did that yourself, it is still running off the old version of the code.

Now, you did execute this code:


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

So the question then becomes: do you have UTL_FILE installed and running on your system and is that directory accessible to UTL_FILE?

If you do not want to deal with any of this and you will simply recompile your code before any test, then use this script:

exec utplsql.autocompile (false);
@ut_acs_object.pks
@ut_acs_object.pkb
exec utplsql.test ('acs_object');

Let me know how it goes. I will post a patched version of utPLSQL on this site probably by end of weekend for you to try out.

Thanks, SF