Spatial (MOSC)

MOSC Banner

No result when geocoding via PL/SQL

edited Apr 1, 2021 9:55AM in Spatial (MOSC) Question

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center