How to Handle UTL_HTTP Response > 32k? (Doc ID 1072214.1)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version 9.2.0.8 and later
Information in this document applies to any platform.
***Checked for relevance on 19th Oct 2016***

Symptoms

Using UTL_HTTP to read a response from a web service that returns an XML document and passes that buffer to XMLTYPE function fails with:

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00007: unexpected end-of-file encountered
ORA-06512: at "SYS.XMLTYPE", line 0
ORA-06512: at line 46

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