ORA-29283 Encountered when file not already created
Hi folks,
I have an unusual problem, or at least something I have not encountered before.
I was engaged to support an issue on a development instance for a package making simple use of UTL_FILE running a package remotely I hit the ORA-29283: invalid file operation error. I have granted READ & WRITE for the directory to the relevant user.
When I login to the LPAR via SSH, login to SQL*Plus as the owning schema and run the procedure, the file is created without issue.
Secondly if I create a dummy file in the filesystem the directory is pointing to, and now run the procedure remotely there is no error and the data is written to the empty file.
I have an unusual problem, or at least something I have not encountered before.
I was engaged to support an issue on a development instance for a package making simple use of UTL_FILE running a package remotely I hit the ORA-29283: invalid file operation error. I have granted READ & WRITE for the directory to the relevant user.
When I login to the LPAR via SSH, login to SQL*Plus as the owning schema and run the procedure, the file is created without issue.
Secondly if I create a dummy file in the filesystem the directory is pointing to, and now run the procedure remotely there is no error and the data is written to the empty file.
0