Product: MapMarker Geocoding Cartridge
Version: 2.0
Platform: Windows NT 4.0
Category: Errors
Summary:
ORA-2000: Error: 9 is thrown by the GeoCodingCartridge for no apparent reason.
Question:
When performing geocoding via PL/SQL script with the Oracle GeoCoding Cartridge v2.0, the below error is thrown. Why could this be happening?
ERROR at line 1:
ORA-20000: Error: 9 Geoaddress has not been geocoded yet. Use findLocation to
geocode.
ORA-06512: at "MISYS.GEOADDRESS", line 321
ORA-06512: at "MISYS.SINGLE_GEOADDR", line 27
ORA-06512: at line 1
Answer:
The above error can occur when geocoding, if empty-string values are supplied for the FIRM, STREET, and STREET2 fields of the concerned geoaddress object. Specifically, the above error message will be displayed if the getNumCandidates field of the geoaddress object is accessed after geocoding has been performed using the "findlocation" function.
The above error is reproducible with the sample PL/SQL script "single_geoaddr.sql" that ships with the GeoCodeCartridge v2.0. To reproduce the error using this PL/SQL script, simply supply empty-string values for the FIRM, STREET, and STREET2 fields of the geoaddress object. Run the script in SQL*PLUS and the error should be displayed.
Last Modified: 09/26/2006 01:38:05 PM
|