UTL_FILE weirdness

Ok, here's a good one. We're running Oracle WGS 7.3.2.1.1 on NT. The documentation for the UTL_FILE package says the following (paraphrased)

1. The UTL_FILE_DIR setting in INIT.ORA is case sensative only on case sensative operating systems.
2. When using the FOPEN function, the specified path and specified filename together must comprise a complete file specification. Meaning, you must include the trailing '/' or '\' on the path. (depending on your OS)

Here's what I found:

Number 1 is false: when my UTL_FILE_DIR setting was "F:\ORANT\RDBMS73\utl_file" and I specified "f:\orant\rdbms73\utl_file" as the path name on my FOPEN call, it failed. I had to match the cases character for character.

Number 2 is false: when I specified "F:\ORANT\RDBMS73\utl_file\" as the path name on my FOPEN call, it failed. I had to REMOVE the trailing '\'.

Any comments?

--
Chris Fischer
Intelligent Information Systems
chrisf_at_renewal-iis.com
(919)572-0901 x231