Database Software

Hi

I'm building an oracle geocoder for Singapore. I'm using the 3 letter ISO code SGP and 2 letter ISO code SG, and have created and populated the following tables:

GC_COUNTRY_PROFILE
GC_PARSER_PROFILEAFS
GC_PARSER_PROFILES
GC_AREA_SG
GC_INTERSECTION_SG
GC_POI_SG
GC_ROAD_SEGMENT_SG
GC_ROAD_SG

However, when I run the following SQL to geocode an address

select SDO_gcdr.geocode('NTQSGPOS',
SDO_keywordArray( '10 MICHIE STREET', '2903'), 'SG', 'DEFAULT')
from dual;

I get the following error:

ORA-29532: Java call terminated by uncaught Java exception: Error: Country name not recoganized:SG
ORA-06512: at "MDSYS.SDO_GCDR", line 678
ORA-06512: at "MDSYS.SDO_GCDR", line 704

If I replace SG with FR (for France)

select SDO_gcdr.geocode('NTQSGPOS',
SDO_keywordArray( '10 MICHIE STREET', '2903'), 'FR', 'DEFAULT')
from dual;

I get the following error:

ORA-29532: Java call terminated by uncaught Java exception: Error: Cannot find Geocoder for
country:FR in user NTQSGPOS
ORA-06512: at "MDSYS.SDO_GCDR", line 678
ORA-06512: at "MDSYS.SDO_GCDR", line 704

Or if I replace SG with XX

select SDO_gcdr.geocode('NTQSGPOS',
SDO_keywordArray( '10 MICHIE STREET', '2903'), 'XX', 'DEFAULT')
from dual;

I get the following error:

ORA-29532: Java call terminated by uncaught Java exception: Error: Country name not recoganized:XX
ORA-06512: at "MDSYS.SDO_GCDR", line 678
ORA-06512: at "MDSYS.SDO_GCDR", line 704

It doesn't seem to recognise SG as a country but I'm sure I've populated all the GC_ tables okay. Had no problems when we were building the geocoder for Australia (AU).

I also noticed that Singapore is not in the sql script

\\navteq\C\oracle\product\10.2\db_1\md\admin\sdogcprs.sql

but France is. Any country not in this sql seems to give the error "Country name not recoganized" so maybe there is another table or configuration file that I need to edit to add SG?

Thanks for your help