Skip to Main Content

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!

Geocoder Problems in France

444920Sep 22 2005 — edited Sep 27 2005
I'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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2005
Added on Sep 22 2005
12 comments
881 views