Geocoding in Autonomous Database
Summary
ORA-29538: Java not installed when trying to call MDSYS.SDO_GCDRContent
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.
Tagged:
0