Ora-22285 - Non-Existent Directory Or File For Loadfromfile
(Doc ID 274695.1)
Last updated on MARCH 04, 2022
Applies to:
PL/SQL - Version 8.1.7.4 to 10.1.0.2 [Release 8.1.7 to 10.1]Information in this document applies to any platform.
Symptoms
1. Running a procedure which loads XML files using DBMS_LOB.LOADFROMFILE(xmlLob,xmlFile,DBMS_LOB.GETLENGTH(xmlFile));
fails with:
ORA-22285: non-existent directory or file for LOADFROMFILE operation
2. Procedure having the call to DBMS_LOB.LOADFROMFILE is being called from another procedure in another schema.
Changes
None
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |