ORA-29532 ORA-942 When running GEOCODING examples (Doc ID 456330.1)

Last updated on JULY 05, 2017

Applies to:

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

Symptoms

When trying to run the GEOCODING examples from the Oracle Spatial document, the following errors are generated:

 

SQL> SELECT SDO_GCDR.GEOCODE('IMT',
2 SDO_KEYWORDARRAY('1 MyHomeTown Pl', 'San Francisco, CA 94102'),
3 'US', 'RELAX_BASE_NAME') FROM DUAL;

SELECT SDO_GCDR.GEOCODE('IMT',
*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
oracle.jdbc.driver.OracleSQLException: ORA-00942: table or view does not exist
ORA-06512: at "MDSYS.SDO_GCDR", line 678
ORA-06512: at "MDSYS.SDO_GCDR", line 704

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