Using APEX 24.1.7 - I have a table which has customer IDs with addresses (multiple addresses for a customer). Would like to show these on the map feature. How do I go about converting ADDRESS, CITY, STATE, ZIPCODE to a SDO geometry or x/y or latitude coordinates so that I can pass them to the Oracle Map?
When I try to use SDO_GCDR.GEOCODE_AS_GEOMETRY and SDO_KEYWORDARRAY, I end up getting
- Ajax call returned server error ORA-44001: invalid schema for .
Any help would be appreciated.
Thank you