I'm trying to add a feature to geoserver (1.7.2 stable) from an Oracle
datastore using the Oracle NG plugin.
The new datastore seems to be created correctly and when I try to add the
new FeatureType the SRS and parameter list are correct - so geoserver has
been able to access Oracle for that information. However, when I click the
Generate button to generate the feature's bounding box, the following error
is returned:
-------------------------------------------------------------------------------------
class java.lang.RuntimeException: java.io.IOException: Error occured
calculating bounds
class java.io.IOException: Error occured calculating bounds
class java.sql.SQLException: 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
Details:
I'm trying to add a feature to geoserver (1.7.2 stable) from
an Oracle datastore using the Oracle NG plugin.
The new datastore seems to be created correctly and when I
try to add the new FeatureType the SRS and parameter list are
correct - so geoserver has been able to access Oracle for
that information. However, when I click the Generate button
to generate the feature's bounding box, the following error
is returned:
class java.lang.RuntimeException: java.io.IOException: Error
occured calculating bounds class java.io.IOException: Error
occured calculating bounds class java.sql.SQLException:
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
Details:
--------------------------------------------------------------
----------------
Open Source Business Conference (OSBC), March 24-25, 2009,
San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing
the Enterprise
-Strategies to boost innovation and cut costs with open
source participation
-Receive a $600 discount off the registration fee with the
source code: SFAD http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
I'm trying to add a feature to geoserver (1.7.2 stable) from an Oracle
datastore using the Oracle NG plugin.
The new datastore seems to be created correctly and when I try to add the
new FeatureType the SRS and parameter list are correct - so geoserver has
been able to access Oracle for that information. However, when I click the
Generate button to generate the feature's bounding box, the following error
is returned:
class java.lang.RuntimeException: java.io.IOException: Error occured
calculating bounds
class java.io.IOException: Error occured calculating bounds
class java.sql.SQLException: 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 Details:
The arcticle seems to suggest all the functions in your trace should be included into the Oracle 11g locator install, but maybe not?
Not sure, I don't have a Oracle 11g with only locator, but seems an
angle worth investigating.
For the record, GeoServer is just running a SELECT SDO_AGGR_MBR(GEOM) FROM TABLE, which should be part of the licensensed functions in Oracle
locator. How one comes down to the SDO_3GL I don't exactly know...
Andrea is the oracle maintainer so he might be able to spot the error specifically, but just a question, does it work with the old oracle driver?
djud wrote:
Hi,
I'm trying to add a feature to geoserver (1.7.2 stable) from an Oracle
datastore using the Oracle NG plugin.
The new datastore seems to be created correctly and when I try to add the
new FeatureType the SRS and parameter list are correct - so geoserver has
been able to access Oracle for that information. However, when I click the
Generate button to generate the feature's bounding box, the following error
is returned:
-------------------------------------------------------------------------------------
class java.lang.RuntimeException: java.io.IOException: Error occured
calculating bounds
class java.io.IOException: Error occured calculating bounds
class java.sql.SQLException: 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 Details: