Morning all,
I've got a problem with the UTL_FILE package on a 7.3.4 database. The
UTL_FILE_DIR initialization parameter is set to *. I define my
filespecs as follows:
file_one UTL_FILE.FILE_TYPE;
BEGIN
file_one:=
You need to handle the exception, for example
Exception
When no_data_found then
dbms_output.put_line ('no data found');
When utl_file.internal_error then
dbms_output.put_line('internal error');
When utl_file.invalid_filehandle then
Thanks IAN,
It confirmed what I already expected - it's a write error. I can't
figure out why though. This directory is owned by the oracle user. It
creates the file, but the refuses to write to it! I've changed the
specification to 'A and given /oracle and /P01 full permissions.
Touched the
Are you out of space or quota? I assume this UFS filesystem. We use AFS here for
quite a bit of stuff. AFS permissions are more granular; a person could have
permissions to create a file but not write to it. The chmod command is still
available, it just doesn't do anything on AFS files.