Re: Help with UTL_FILE under 7.3.2?

There are are couple of things you can do to check this a bit further;

1. Execute the query;

select value from v$parameter where name = 'utl_file_dir';

This should return the directory that utl_file_dir is set to and can be used to confirm that it is being set correctly.

2) Check the permissions of the directory and file you are looking at. The UTL_FILE package will read and write with the permissions of the oracle owner (due to the setuid of the oracle executable) so it may be possible that this user does not have access to what you are trying to read.

Hope this helps,

Ian Received on Wed Oct 15 1997 - 00:00:00 CEST