This content has been marked as final. Show 1 reply
check your data (are all the columns filled, and are they filled with the proper data?), and expand your Parser profile.
What do you get when you execute this:
instead of using the custom function to return an address array from a POI?
SELECT SDO_GCDR.GEOCODE_ADDR ( 'LOCALIZAME_SV', SDO_GEO_ADDR ( 'SV', -- COUNTRY 'DEFAULT', -- MATCHMODE 'Calle Arce No.123', -- STREET NULL, -- SETTLEMENT NULL, -- MUNICIPALITY 'San Salvador', -- REGION NULL -- POSTALCODE ) ) FROM DUAL;
Besides the excellent book "Pro Oracle Spatial for Oracle Database 11g" I would also check the [url http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_geocode_concepts.htm#CIHECECC]documentation. This link assumes you are using Oracle 11R2, allthough you did not provide your database version.
PS. please do not dig up old threads, when you've already created one with your question.