An Insert into a SYS.XMLTYPE STORAGE BINARY Column Fails with Error ORA-7445:[LpxFSMEvNext]
(Doc ID 1625400.1)
Last updated on MARCH 10, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
In 11.2.0.4 an insert statement into a SYS.XMLTYPE STORAGE BINARY column fails with error
ORA-07445: exception encountered: core dump [LpxFSMEvNext()+19236]
If the workaround of <Bug 11666959> is put in place then the INSERT completes successfully.
The workaround is -
alter session set events= '31156 trace name context forever, level 0x400';
The INSERT statement can be like the following one:
INSERT /* ^^UNIQUE_ID */
INTO TMP_XML (ENTITY, CDATE, PART, XML_XML)
SELECT 'COLLATERAL', sysdate, 1,
-- XMLType.createXML(
XMLELEMENT ("COLLATERAL",
XMLCONCAT (XMLELEMENT ("HEADER",
xmlattributes ('BREBANK' AS "SYSTEM",
'COLLATERAL' AS "OBJECT",
MAX (repdate_d) AS "BUSINESS_D",
'001' AS "VERSION", COUNT (*) AS "RECORD_COUNT")),
XMLAGG (XMLELEMENT ("DATEN",
xmlattributes
(collateral_id_ind, currency_c, collateral_type_ind,
collateral_type_supp_ind AS "COLLATERAL_TYPE_SUPPLEMENTARY_IND",
booking_entity_ind,
partial_use_f,
rating_agency_ind, rating_ind, rating_maturity_f,
date_of_trade_d, date_of_maturity_d, collateral_class_sa_ind,
partner_id_ind,
repdate_d,
sme_f,
sme_supporting_factor_f, residual_maturity_ind)))))--.getblobval
(NLS_CHARSET_ID ('WE8ISO8859P1'))
-- , NLS_CHARSET_ID ('WE8ISO8859P1'), null)
AS COLLATERAL
FROM TMP_COLLATERAL
;
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 |