Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SDO_3GL error

650828Mar 2 2009 — edited Mar 24 2009

Hi,

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 21 2009

Added on Mar 2 2009

#database-key-features, #spatial

4 comments

2,863 views