URGENT HELP re: UTL_FILE needed

(NT 4.0 SP3, Oracle 7.3.3.0.0)

I absolutely cannot get UTL_FILE.FOPEN to work. I get an invalid directory message every time. I've got UTL_FILE_DIR set in initxxx.ora.  I've made sure case matches between init.ora and my script. I've tried it with and without a '\' in initxxx.ora and in my script. I've tried UTL_FILE_DIR=*. I've tried the root directory and subdirectories. And I've created an NT user named oracle and created the subdirctory I'm trying to write to using that user.

I'm running the script on the server (but its an anonymous PL/SQL script, not a compiled one--would that make a difference?) I can't think of anything else to try.

I've noticed a couple of other people seemed to have the same problem. Has anyone found a solution?

Thanks very much,

Bob

--
Bob M.

Step outside. The graphics are AMAZING!

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 07 1999 - 23:15:54 CDT