Select With XML Fails With ORA-07445 [kghalo] (Doc ID 1459135.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 10-Jan-2014***

Symptoms

Following errors are reported in the alert.log:

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x9FFFFFFFBFFFF000] [PC:0x40000000065AC6A0, kghfnd()] [flags: 0x0, count: 1]
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x9FFFFFFFBFFFF1F8] [PC:0xC000000000C21F40, uwx_restore_rnat()+320] [flags: 0x2, count: 2]

 

Error in trace file:

ORA-07445: exception encountered: core dump [kghalo()] [SIGSEGV] [ADDR:0x9FFFFFFFBFFFF000] [PC:0x40000000065AAFE0] [Address not mapped to object]

 

There may or may not be a current SQL reported in the trace file:

SELECT Xmlagg(Xmlelement("OPERAZIONE", Xmlforest( --
                     w.Id_Fz, --
                     f.c_Funzione, --
                     f.Ds_Funzione, --
                     w.Id_Op, --
                     w.Id_Ext, --
                     w.c_Operazione, --
                     o.Ds_Operazione, --
                     w.Id_Sogg_H2o, --
                     w.Id_Sogg_Mifid, --
                     w.Id_Sogg_H2o_Disp, --
                     w.Id_Sogg_Mifid_Disp, --
                     w.x_Chkfz_Xml, --
                     w.c_Stato, --
                     s.Ds_Stato, --
                     TO_CHAR(w.d_Stampa, 'DD/MM/YYYY') d_Stampa, --
                      (SELECT Xmlagg(Xmlelement("OPERAZIONE",
                                               Xmlforest( --
                                                         s.Id_Op, --
                                                         s.c_Stampa, --
                                                         s.Id_Busta10))) --
                        FROM TABLE(w.Tbl_Dati_Stampa) s) Tbl_Dati_Stampa, --
                     TO_CHAR(w.d_Firma, 'DD/MM/YYYY') d_Firma, --
                     Wrk_Op_Firmata.c_Operazione c_Operazione_Firmata, --
                     TO_CHAR(Wrk_Op_Firmata.d_Stampa, 'DD/MM/YYYY') d_Stampa_Op_Firmata, --
                     TO_CHAR(Wrk_Op_Firmata.d_Firma, 'DD/MM/YYYY') d_Firma_Op_Firmata, --
                     Wrk_Op_Firmata.Id_Ext Id_Ext_Firmata))).Getclobval()
     FROM Mcore_Tr_Valid_Wrk w,
          Mcore_Ma_Valid_Stati s,
          Mcore_Ma_Valid_Op o,
          Mcore_Ma_Valid_Fz f,
          Mcore_Tr_Valid_Wrk Wrk_Op_Firmata
    WHERE s.c_Stato = w.c_Stato
      AND o.c_Operazione = w.c_Operazione
      AND f.c_Funzione = w.c_Funzione
      AND Wrk_Op_Firmata.Id_Fz(+) = w.Id_Fz
      AND Wrk_Op_Firmata.Id_Op(+) = w.Id_Op_Firma
      AND Wrk_Op_Firmata.Id_Op(+) < Wrk_Op_Firmata.Id_Op_Firma(+)
    ORDER BY w.Id_Op;

----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
c00000029aefd808      3233  package body TITALL_DBA.MF_PKG_VALIDATORE_2012
c00000029aefd808      3954  package body TITALL_DBA.MF_PKG_VALIDATORE_2012
c0000002976a6cb8         1  anonymous block

 

 

Call stack:

skdstdst ksedst dbkedDefDump ksedmp ssexhd kghalo kghgex kghfnd kghalo  kghgex
kghalf kghalp qctoxop qctcopn qmxtgr2TypeCheck qmxtcTypeCheckOpn2 qmxtr2InitNewOp
qmxtr2CrtMKElem qmxtr2XFC2CXE qmxtr2oxmlcolelem kokqbpo kokqbpt kokqbpt kokqbpo
kokqbpt kokqbpt kokqbpo kokqbpt kokqbpt kokqbpo kokqbpt kokqbpt kokqbpo kokqbpt
kokqbpt kokqbpo kokqbpt kokqbpt kokqbpo kokqbpt kokqbpt kokqbpo kokqbpt kokqbpt
kokqbpo kokqbpt kokqbpt kokqbpo kokqbpt kokqbpt kokqbpo kokqbpt kokqbpt kokqbpo
kokqbpt kokqbpt kokqbpo kokqbpt kokqbpt

 

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