ORA-7445 [evaopn3] While running XML query
(Doc ID 2356070.1)
Last updated on APRIL 12, 2022
Applies to:
Oracle Database Exadata Cloud Machine - Version N/A and laterOracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
DB Version: 12.1.0.2
OS Version: Microsoft Windows x64 (64-bit)
An XML query fails with the following errors:
SQL> SELECT <columns> , EXTRACTVALUE (VALUE (inv), '<path1>') sku_no, EXTRACTVALUE (VALUE (inv), '<path2>') qty
FROM (SELECT xml_message data, xml_id, .... FROM .....) t, TABLE(XMLSEQUENCE (EXTRACT (data, '<path>'))) inv) <alias>,
(SELECT ... FROM ... WHERE ... GROUP BY ... ) <alias>
WHERE .... GROUP BY ....
SELECT ....
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 20984
Session ID: 17 Serial number: 38379
ORA-07445: exception encountered: core dump [evaopn3()+107] [SIGSEGV] [ADDR:0x0] [PC:0xCEA994B] [Address not mapped to object] []
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |