(map to root directory)
CREATE OR REPLACE DIRECTORY MYDIR AS ‘/’;
UTL_FILE.FOPEN(MYDIR, <filename>, ‘W’)
(both creation of directory and calling utl_file.fopen() is done as SYS user).
Running the above utl_file.fopen() gives “ORA-17410: No more data to read from socket” error.
I understand that we are mapping it to root directory, so we may not have necessary OS user privileges to create/write to a file. But why is this specific error thrown? Why is the database connection getting reset?
If I create the database directory schema object and map it to some other file system directory where the user does not have necessary write privileges - the following error is thrown - “ORA-29283: invalid file operation: cannot open file [29435]”. This error is understandable.
How is root directory giving ORA-17410 error and not ORA-29283?
Thanks