SDO_AGGR_UNION ORA-30625: Method Dispatch On NULL SELF Argument Is Disallowed

(Doc ID 1633395.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

A procedure that includes a SELECT with MDSYS.SDO_AGGR_UNION when executed the second time time it generates error

  ORA-30625: method dispatch on NULL SELF argument is disallowed

This is the procedure

  CREATE OR REPLACE PROCEDURE TEST_P AS
  BEGIN
  DECLARE
  CURSOR c_comp IS
  --SELECT MDSYS.SDOAGGRTYPE(b.GEOM, .05) gg -- without SDO_AGGR_UNION(), works both in 11g and 12c
  SELECT MDSYS.SDO_AGGR_UNION(MDSYS.SDOAGGRTYPE(b.GEOM, .05)) gg
  FROM SR_TEST b
  WHERE b.area_id = '01073005500';
  BEGIN
  FOR c IN c_comp
  LOOP
  NULL;
  END LOOP;
  END;
  EXCEPTION
  WHEN OTHERS THEN
  RAISE;
  END TEST_P;
  /

exec test_p;

PL/SQL procedure successfully completed.

exec test_p;

ERROR at line 1:
ORA-30625: method dispatch on NULL SELF argument is disallowed
ORA-06512: at "SDOBUG.TEST_P", line 17
ORA-06512: at line 1

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