Search code examples
xmloracleoracle21c

ORA-22288: file or LOB operation FILEOPEN failed, access denied

I would like to store an xml file in oracle database and I did the following :

create table MyTab (filename varchar(64), xml XMLType);

create or replace directory XML_DIR as 'C:\Users\XXX\XXX\Folder\xml';

insert into MyTab VALUES ('file.xml', xmltype(bfilename('XML_DIR','file.xml'),nls_charset_id('AL32UTF8')));

However i have this error : ORA-22288: file or LOB operation FILEOPEN failed, access denied

Can someone explain what is wrong, please?

Solution

  • To give Oracle permission to use a directory on Windows:

    1. Open Windows Explorer
    2. Right-click on the relevant folder
    3. Click Properties
    4. Click Security
    5. Click Edit...
    6. Click Add...
    7. Click Advanced...
    8. Click Find Now...
    9. Double-click on a name like "ORA_OraDB19Home1_SVCACCTS" (this will be different depending on your version and on how you installed Oracle, and I think that "ORA_DBA" may also work for some versions)
    10. Click OK three times