Geocoder Problems in France
444920Sep 22 2005 — edited Sep 27 2005I'm currently having difficulty geocoding with French data. I can geocode correctly with US, Canadian, Irish, English and German data. I'm getting errors soley with French data. When I geocode using the Geocoder servlet it works. When I geocode through SQLplus i get errors.
The error I get from SQLPLUS is
FR@NAVQ404:SQL> SELECT SDO_GCDR.GEOCODE('FR', SDO_KEYWORDARRAY('91','Boulevard Saint Germain','Paris','Paris 75009'), 'FR', 'RELAX_STREET_TYPE') FROM DUAL;
SELECT SDO_GCDR.GEOCODE('FR', SDO_KEYWORDARRAY('91','Boulevard Saint Germain','Paris','Paris 75009'), 'FR', 'RELAX_STREET_TYPE') FROM DUAL
*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.lang.NullPointerException
ORA-06512: at "MDSYS.SDO_GCDR", line 644
ORA-06512: at "MDSYS.SDO_GCDR", line 670
And when I check the user dump file on the server the following exception exists
java.lang.NullPointerException
at oracle.spatial.geocoder.parser.AddressFormatProfile.updateTableDB(AddressFormatProfile.java:275)
at oracle.spatial.geocoder.parser.AddressFormatProfile.readDataFromProfileDB(AddressFormatProfile.java:170)
at oracle.spatial.geocoder.parser.AddressFormatProfile.<init>(AddressFormatProfile.java:124)
at oracle.spatial.geocoder.SQLGeocoderStub.geocodeAddress(SQLGeocoderStub.java:329)
Has anyone experienced this problem or can someone at Oracle tell me what the null pointer at that line code be.
Thanks