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:

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

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