My Oracle Support Banner

Select With XMLTABLE And XMLTYPE Throws ORA 7445 [evaopn3()+125] (Doc ID 1580106.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

The following select query failed with following error:

select S.DerivCore,f.dated_dt
FROM wsowner."SecurityReferences_TAB" st, XMLTABLE(
  XMLNAMESPACES ('http://www.trp.com/gml/schemas/rd/v0.1' AS "rd"),
  'for $r in /rd:SecurityReferences/SecurityReference return $r'
  
  passing st.OBJECT_VALUE
  COLUMNS
  DerivCore XMLTYPE path 'DerivativesCore',
  FICore XMLTYPE path 'FICore'
  ) S,
  XMLTABLE(
  'DerivativesCore/OptionsCore'
  passing DerivCore
  columns
  strikePrice VARCHAR2(20) PATH 'strikePrice/text()',
  expirationDt DATE PATH 'expirationDt/text()'
  )D,
  XMLTABLE(
  'FICore/IssueDetail'
  passing FICore
  columns
  DATED_DT DATE PATH 'issueDt/text()'
  )F;

 

ORA-07445 exception encountered: core dump [evaopn3()+125] [SIGSEGV] [ADDR:0x4] [PC:0x928D035] [Address not mapped to object] []

 

The Call Stack is:

sighandler <- evaopn3 <- qerjoFetch <- qerflFetchOutside
        <- opifch2 <- kpoal8 <- opiodr <- ttcpip <- opitsk
         <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
          <- ssthrdmain <- main <- libc_start_main

  

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


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