ORA-31020 error if I try to insert xml files which has reference to schema.
Hi,
When I try to insert xml/html files which needs to be validated with xml schema, I'm getting the following error.
ORA-31020: The operation is not allowed, Reason: For security reasons, ftp and http access over XDB repository is not allowed on server side.
I have already registered that particular schema in the XDB repository. When I try to insert the xml file without referencing any xml schema, I'm able to successfully insert. But I'm not able to insert the same file with xml schema reference. Since some entity references will be made in some of the html files, I need to insert the file with DTD/schema reference only.I am facing this problem in Oracle database 11gR2(11.2.0.2) installed in Linux(32-bit machine). I'm able to successfully insert xml/html files with schema reference in oracle database 11gR2(11.2.0.1) installed in Windows(32-bit machine). I'm trying to use Binary xml storage. I read the recent tutorials, and learnt that in 11.2.0.2, "Prior to Oracle Database 11g Release 2 (11.2.0.2), binary XML data was stored by default using the BasicFile LOB storage option. By default, LOB storage for binary XML data now uses the SecureFile LOB storage option whenever possible." Is this securefile LOB storage creating this problem? Is there a way to solve this issue. It will be really great if anyone could help me in solving this issue..
Thanks,
Divya.