You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Geocoding in Autonomous Database

Received Response
11
Views
2
Comments
edited Apr 16, 2022 7:54AM in Autonomous Database 2 comments

Summary

ORA-29538: Java not installed when trying to call MDSYS.SDO_GCDR

Content

Hi,

I hope you can help as I couldn't find any support on google for my particular issue relating to Autonomous Database. I'm trying to perform geocoding on unformatted address data as a training exercise to understand how geocoding works in Oracle. I'm using the SDO_GCDR package but I'm getting Java not installed errors.

SELECT sdo_gcdr.geocode_as_geometry('AWCEXT',SDO_KEYWORDARRAY('1970 Napa Ct.', 'Bothell, WA  98011'),'US')
  FROM dual;

ORA-29538: Java not installed
ORA-06512: at "MDSYS.SDO_GCDR", line 742
ORA-06512: at "MDSYS.SDO_GCDR", line 790
29538. 00000 -  "Java not installed"
*Cause:    An attempt was made to use a Java command when Java is not installed.
*Action:   Install Java, or do not use the command.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!