Previous | Next
Topic: Getting utPLSQL to work under Unix
Conf: 537, Msg: 37921
From: Steven Feuerstein (steven@stevenfeuerstein.com)
Date: 9/22/00 09:23 AM

Getting utPLSQL to work under Unix Steven Feuerstein sfeuerstein steven@stevenfeuerstein.com Thanks for identifying a few of those install glitches. I am fixing those now and will shortly publish a new version with a cleaner install process.

In terms of your error: I need to improve error handling where UTL_FILE is concerned, but this statement:

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

is likely to cause problems. Try removing the trailing /, as in:

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

Now in terms of your code, I believe that my doc still includes some references to the # as a delimiter, as in ut#xxxx. That is bad, bad, bad. Based on some early feedback, (such as: the use of # causes problems on Unix systems), I switched to using _, as in ut_mypackage.

So unless you override the default with the use of ut#, it will not find your test code.

I am also in the process of converting all doc to HTML and cleaning it up. Thanks for your patience!

Please let us know if this fixes your problem.

SF