This discussion is archived
0 Replies Latest reply: Jan 29, 2013 12:13 PM by 975287 RSS

GEOCODER Spatial Developper's guide error

975287 Newbie
Currently Being Moderated
Hi!

In the Oracle® Spatial Developer's Guide 11g Release 2 (11.2) E11830-11 of May 2012

At page 11-22 (or p. 288), section "11.5.7 GC_POI_<suffix> Table"

Under "Table 11–13 GC_POI_<suffix> Table"

It is mentionned "POI_NAME VARCHAR2(64) Name of the POI. (Required)"

Oracle geocoder is actually looking for the "NAME" Column and not the "POI_NAME".

The documentation should be updated.

Here is the error I got from using "POI_NAME" :

13/01/29 14:18:57 [oracle.spatial.geocoder.server.GeocoderImpl, Tue Jan 29 14:18:57 EST 2013, ERROR] Error: ORA-00904: "NAME": invalid identifier
at oracle.spatial.geocoder.server.POI.fetchPoi(POI.java:370)
at oracle.spatial.geocoder.server.POI.resolve(POI.java:160)
at oracle.spatial.geocoder.server.GenericGeocoder.matchPOI(GenericGeocoder.java:1158)

jb

Edited by: 972284 on Jan 29, 2013 3:13 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points