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!

SDO_gcdr.geocode_all not working w/adci data

434181Feb 16 2007
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2007
Added on Feb 16 2007
0 comments
482 views