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