SDO_3GL error
650828Mar 2 2009 — edited Mar 24 2009Hi,
I'm using Oracle spatial (Oracle Database 10g Release 10.2.0.4.0 - 64bit Production) and GeoServer for a mapping application. GeoServer makes the following request as part of its geom boundary calculations:
select sdo_aggr_mbr(geom) from table;
but it's failing with the error:
ORA-04063: package body "MDSYS.SDO_3GL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "MDSYS.SDO_3GL"
ORA-06512: at "MDSYS.SDO_GEOM", line 3398
ORA-06512: at "MDSYS.SDO_GEOM", line 3507
ORA-06512: at "MDSYS.SDOAGGR", line 41
ORA-06512: at "MDSYS.AGGRMBR", line 14
I get the same error even if I just run the select in an Oracle command window.
Does anyone understand the problem here or know of a fix?
Any help appreciated,
Dave