Geocoding in Autonomous Database
SummaryORA-29538: Java not installed when trying to call MDSYS.SDO_GCDR
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.