ORA-31020 from external DTD validation
(Doc ID 1407634.1)
Last updated on JANUARY 20, 2020
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.1 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
***** Checked for Relevance on 04-May-2015 *****
External DTD validation fails with errors since upgrading to 11g:
SQL> SELECT extractValue(xml_data, '/properties/entry[@key="abc"]') tag_value
2 FROM ( SELECT XMLType(
3 '<?xml version = "1.0" encoding = "UTF-8"?>
4 <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
5 <properties><entry key="abc">Some Data</entry></properties>') xml_data
6 FROM DUAL );
FROM ( SELECT XMLType(
ERROR at line 2:
ORA-31020: The operation is not allowed, Reason: For security reasons, ftp and http access over XDB repository is not allowed on server side
ORA-06512: at "SYS.XMLTYPE", line 310
ORA-06512: at line 1
Database was upgraded from 10g to 11g.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document