ORA-07445: exception encountered: core dump [pmuocpy2_copy_recur()+432] in SDO_GEOR.getCellValue Query (Doc ID 1582356.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

A select statement using MDSYS.SDO_GEOR.getCellValue generates internal error

CREATE OR REPLACE FUNCTION PUNTO(
  x number,
  y number,
  z number DEFAULT NULL,
  srid number DEFAULT NULL
  )
  RETURN MDSYS.SDO_GEOMETRY
DETERMINISTIC
IS
BEGIN
IF x IS NULL OR y IS NULL THEN
RETURN NULL;
END IF;
  RETURN MDSYS.SDO_GEOMETRY(2001,srid,MDSYS.SDO_POINT_TYPE(x,y,z),NULL, NULL);
END;
/

It works fine when the output is only one row

select georid,
MDSYS.SDO_GEOR.getCellValue(GEORASTER,0,
PUNTO(2,2),1) ozono
FROM GEORASTER_TABLE
WHERE georid=1;

  GEORID OZONO
---------- ----------
  1 13

It breaks when the output is more than one row:


select georid,
MDSYS.SDO_GEOR.getCellValue(GEORASTER,0,
PUNTO(2,2),1) ozono
FROM GEORASTER_TABLE
WHERE georid=1 or georid=2;

ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 14562
Session ID: 195 Serial number: 39

Error in trace file:
ORA-07445: exception encountered: core dump [pmuocpy2_copy_recur()+432] [SIGSEGV] [ADDR:0x0] [PC:0x93C3D78] [SI_KERNEL(general_protection)] []

The query works if we use the MDSYS.SDO_GEOMETRY(2001,srid,MDSYS.SDO_POINT_TYPE(x,y,z),NULL, NULL) instead of the function PUNTO

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