SDO_gcdr.geocode_all not working w/adci data
Hello,
i downloaded the adci sample data for north america and installed themo on a 10.2.0.1.0 server running on windows xp professional.
Before loading the data I applied the 5632711 patch to the routing server.
Everything went fine, even the suggested test:
select SDO_gcdr.geocode('ADCI',
SDO_keywordArray( '1052 Thomas Jefferson St','Washington, DC 20007'), 'US', 'DEFAULT')
from dual ;
worked fine.
However, the call:
select SDO_gcdr.geocode_all('ADCI',
SDO_keywordArray( '1052 Thomas Jefferson St','Washington, DC 20007'), 'US', 'DEFAULT')
from dual ;
gave the following error message:
Error starting at line 4 in command:
select SDO_gcdr.geocode_all('ADCI',
SDO_keywordArray( '1052 Thomas Jefferson St','Washington, DC 20007'), 'US', 'DEFAULT')
from dual
Error report:
SQL Error: ORA-06502: PL/SQL: errore : errore di conversione da carattere a numero di numero o valore
ORA-06512: a "MDSYS.SDO_GCDR", line 558
ORA-06512: a "MDSYS.SDO_GCDR", line 629
ORA-06512: a "MDSYS.SDO_GCDR", line 758
ORA-06512: a line 1
06502. 00000 - "PL/SQL: numeric or value error%s"
*Cause:
*Action:
which apparently is an internal error (the message (in italian) means that there is a an error in the conversion from character to number or value)
I tried different calls to geocode_all without success.
Can someone help me?
Thanks in advance, cheers