plamen9

declare
    l_prompt            clob;
    l_response          clob;
    l_response_text     clob;
    l_prompt_tokens     number;
    l_completion_tokens number;
    l_total_tokens      number;

    chatgpt_error EXCEPTION;
    PRAGMA exception_init(chatgpt_error, -20001);

plamen9

-- *** Types conversion examples ***
 
-- Convert SDO_GEOMETRY to GeoJSON
select apex_json.stringify( 
 mdsys.sdo_geometry( 2001, 4326, sdo_point_type( 10, 50, null ), null, null ) 
 )
from dual;

select apex_json.stringify( 
 MDSYS.SDO_GEOMETRY(2002, NULL, NULL, 

plamen9

-- *** Single Point *** 
 
-- GeoJSON
{"type": "Point", "coordinates": [-0.051, 51.50254]}

-- SDO_GEOMETRY
MDSYS.SDO_GEOMETRY(2001, 4326, MDSYS.SDO_POINT_TYPE(-0.051, 51.50254, NULL), NULL, NULL);

-- Longitude/Latitude
Longitude: -0.051

plamen9

var lMapRegion   = apex.region("map_search"),
    // important: Use the layer name exactly as specified in the "name" attribute in Page Designer
    lLayerId     = lMapRegion.call("getLayerIdByName", "Map Search"),
    lCurrentZoom = lMapRegion.call("getMapCenterAndZoomLevel").zoom,
    lLocationId  = apex.item("P27_GEOLOCATOR").getValue(),
    lFeature     = lMapRegion.call("getFeature", lLayerId, lLocationId ),
    lPosition;

console.log("lLocationId -> " + lLocationId);