33.33 STRINGIFY Function Signature 5
This function converts p_value
to a GeoJSON value.
Note:
This signature is only available if SDO_GEOMETRY (Oracle Locator) is installed in the database.Syntax
APEX_JSON.STRINGIFY (
p_value IN mdsys.sdo_geometry )
RETURN CLOB;
Parameters
Table 33-45 STRINGIFY Parameters
Parameter | Description |
---|---|
p_value |
The date value to be converted. |
Returns
Table 33-46 STRINGIFY Returns
Return | Description |
---|---|
VARCHAR2 |
The GeoJSON value. |
Example
The following example prints GeoJSON values.
BEGIN
sys.htp.p(apex_json.stringify(
mdsys.sdo_geometry( 2001, 4326, sdo_point_type( 10, 50, null ), null, null ) ) );
END;
Parent topic: APEX_JSON