Getting a "No such file or directory" error when executing procedure
All, I have a pl/sql procedure that loads data from xml files into database tables. The xml files reside on a unix server and we just ran a chmod 777 on all the files therefore permission should not be an issue and yet when I execute the procedure, I get a permission denied error among other things. The following is the output of executing the procedure
"I am in OTHERS Exception Block....ORA-22288: file or LOB operation GETLENGTH failed
No such file or directory".
I manually enter the file name and the path directory into a separate database table and these values are assigned to local variables in the procedure and processed within. I am executing this procedure from staging, and when I execute the same procedure for the exact same file in dev, it works fine. I get the above error when executing from stage. Permissions should not be a problem since there is 'rwxrwxrwx' on all the xml files and directories. Any ideas why the above error appears?