UTL_FILE paths

In my init.ora file I have --

utl_file_dir = /usr/tmp

which is suppose to define the path into which a file can be opened when using the utl_file package. However, in my pl/sql code, when I make a call such as

declare
  file_id utl_file.file_type;
begin
[Quoted]   file_id := utl_file.fopen('/usr/tmp/','test.lis','W');
....
....

...
the invalid path exception is raised. Any ideas on why this would be? The permissions are open on /usr/tmp. When I change the utl_file_dir parameter to be

utl_file_dir = *

the fopen command works fine. Again, anyone have a clue why the code is not working properly?

Thanks in advance,

Mike Shoop Received on Fri Feb 27 1998 - 00:00:00 CET