LPX-00104 Is Raised Since 11.2.0.2 For An XML Document With An Inline DTD Having No Element Defined (Doc ID 1424273.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Oracle XML Developers Kit - Version: 11.2.0.2 and later    [Release: 11.2 and later]
Information in this document applies to any platform.

Symptoms

Inserting an XML document containing a DTD declaration into an XMLType fails with following errors

ORA-31061: XDB error: XML event error
ORA-19202: Error occurred in XML processing
In line 6 of orastream:
LPX-00104: Warning: element "standard" is not declared in the DTD

Example of XML document

<?xml version="1.0" encoding="UTF-8" standalone='yes'?>
<!DOCTYPE standard [
<!NOTATION png SYSTEM "">
<!ENTITY GREG1 SYSTEM "GREG1.png" NDATA png>
]>
<standard>
<artwork name="GREG1"/>
</standard>

Example of code:

connect / as sysdba
create directory tmpxmldir as '/tmp';
grant read, write on directory tmpxmldir to scott;

connect scott/tiger
create table GGDOC of xmltype xmltype store as binary xml;
insert into ggdoc values (xmltype(bfilename('TMPXMLDIR','test1.xml'), nls_charset_id('AL32UTF8')));

Changes

The database has been upgrade from the version 11.2.0.1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms