My Oracle Support Banner

ORA-31024: Parser initialization failed with LPX-54 error while parsing a stream to XOB When Using extractvalue (Doc ID 2733942.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


On after installing OCT patch, the following error is reported from the application side:

ORA-31024: Parser initialization failed with LPX-54 error while parsing a stream to XOB

Checking the trace file, this is the query executed at the time of the error:

SELECT extractvalue(xmlval, '/*/info[@type = "sql_profile"]'), extractvalue(xmlval, '/*/info[@type = "outline"]'), extractvalue(xmlval, '/*/info[@type = "dynamic_sampling"]'), nvl(extractvalue(xmlval, '/*/info[@type = "index_size"]'), -1) from (select xmltype(other_xml) xmlval from dba_hist_sql_plan where sql_id = :1 and other_xml is not null and id = 1)


Running this directly on the database, it works fine (no error reported).



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.