No result when geocoding via PL/SQL
Dear community,
I am trying to geocode an unformatted address and returns the result as an SDO_GEOMETRY object.
Looking at this closer I have to use GEOCODE_AS_GEOMETRY function from package SDO_GCDR.
Point of view database spatial components are looking at first glance good point of view setup:
select comp_id, comp_name, version, status from dba_registry where comp_id in ('JAVAVM','ORDIM','XDB','SDO');
COMP_ID COMP_NAME VERSION STATUS
------------------------ -------------------------------------------------- ------------------------ ------------------------
JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 VALID
XDB Oracle XML Database 12.2.0.1.0 VALID
ORDIM Oracle Multimedia 12.2.0.1.0 VALID
SDO Spatial 12.2.0.1.0 VALID
And MDSYS user exists & locked.