Script with XMLForest Query Fails with Core Dump, ORA-7445 qmsqxStreamEvalXMLOp, on 11.1.0.7 (Doc ID 975505.1)

Last updated on FEBRUARY 04, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 to 11.1.0.7 - Release: 11.1 to 11.1
Information in this document applies to any platform.

Symptoms

On 11.1.0.7 version, when attempting to run scripts with XMLForest the following error occurs:

ORA-07445: exception encountered: core dump [PC:0x0] [ACCESS_VIOLATION] [ADDR:0x0] [PC:0x0] [UNABLE_TO_WRITE] []
...
----- Current SQL Statement for this session (sql_id=c1bncuzgsbmya) -----
SELECT XMLELEMENT( "ROWSET", XMLATTRIBUTES('http://www.w3.org/2001/XMLSchema-instance' AS "xmlns:xsi", 'http://health.version1.com/xsd/health.xsd' AS "xsi:noNamespaceSchemaLocation"), XMLELEMENT(INS, (SELECT XMLAGG(XMLELEMENT(TD_INSTANCE, XMLFOREST(INSTANCE_NAME AS INS_SID, TO_CHAR(TRUNC(STARTUP_TIME),'DD-MM-YYYY') AS INS_STARTUP_TIME, DATABASE_STATUS AS INS_DB_STATUS, ACTIVE_STATE AS INS_ACTIVE_STATE, VERSION AS INS_VERSION, HOST_NAME AS INS_HOSTNAME, TO_CHAR(TRUNC(SYSDATE),'DD-MM-YYYY') AS INS_SYSTIME)))


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