An Insert into a SYS.XMLTYPE STORAGE BINARY Column Fails with Error ORA-7445:[LpxFSMEvNext] (Doc ID 1625400.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 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

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