Dear all,
/tmp can be found in v$parameter (utl_file_dir) but I still got invalid directory path error using utl_file.fopen
Below is my testing code:
declare
l_utl_file UTL_FILE.FILE_TYPE;
begin
l_utl_file := UTL_FILE.FOPEN('/tmp', 'testing.txt', 'w', 4000);
UTL_FILE.PUT_LINE( l_utl_file, 'testing');
UTL_FILE.FCLOSE(l_utl_file);
end;
/
1) But it works if I replace the "/tmp" by a directory object created for "/tmp" using "create directory" command in database.
2) It also works if I replace "/tmp" by the first directory listed in utl_file_dir parameter. Seems like only the first directory of utl_file_dir string is valid
Is that absolute path is no longer supported in utl_file.fopen ? Or some setup that I am missing in the database ?
Regards,
Christine