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 DECEMBER 03, 2020

Applies to:

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

Symptoms

On 12.1.0.2 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).

 

Cause

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
Symptoms
Cause
Solution
References


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