Error Processing Large XML File
Executed in SQL Developer Version 4.1.3.20.
I'm trying to run the query below and I'm getting an error.
Query:
select XMLTYPE(Bfilename ('DIR_TEMP', 'Temp.xml'),nls_charset_id('AL32UTF8')) from dual
Error:
ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 1
LPX-00240: element-start tag is not well formed
ORA-06512: at "SYS.XMLTYPE", line 296
ORA-06512: at line 1
31011. 00000 - "XML parsing failed"
The document size is 4,275,728KB. The Bfilename size is 4378344931 (got this via dbms_lob.getlength).
I checked the file and it contains all the elements. Is it possible that I'm getting the error because of the size? Does XMLTYPE have that limitation? I ran just the Bfilename ('DIR_TEMP', 'Temp.xml') and the query executes without error.