My Oracle Support Banner

SELECT SDO_GCDR.GEOCODE_ALL CAUSES ORA-29532 ERROR (Doc ID 1066170.1)

Last updated on FEBRUARY 07, 2019

Applies to:

Oracle Spatial and Graph - Version 10.2.0.4 to 11.2.0.1.0
Information in this document applies to any platform.

Symptoms


Using Oracle's Geocoder with Navteq Parser Profiles from Q109 or Q309:

When running a similar query (to test geocode):

select sdo_gcdr.geocode_all('NAVTEQ', sdo_keywordarray('<street address>', '<city>', '<state>', '<zip code>'), 'US', 'DEFAULT') x from dual;

The following errors are generated:

select sdo_gcdr.geocode_all('NAVTEQ', sdo_keywordarray('<street address>', '<city>', '<state>', '<zip code>'), 'US', 'DEFAULT') x from dual
*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
ORA-06512: at "MDSYS.SDO_GCDR", line 643
ORA-06512: at "MDSYS.SDO_GCDR", line 759
ORA-06512: at line 1

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.