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 and later
Information in this document applies to any platform.


The following select query failed with following error:

select S.DerivCore,f.dated_dt
FROM wsowner."SecurityReferences_TAB" st, XMLTABLE(
  'for $r in /rd:SecurityReferences/SecurityReference return $r'
  passing st.OBJECT_VALUE
  DerivCore XMLTYPE path 'DerivativesCore',
  FICore XMLTYPE path 'FICore'
  ) S,
  passing DerivCore
  strikePrice VARCHAR2(20) PATH 'strikePrice/text()',
  expirationDt DATE PATH 'expirationDt/text()'
  passing FICore
  DATED_DT DATE PATH 'issueDt/text()'


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



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

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