STRINGIFY Function Signature 5

37.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

Parameter	Description
`p_value`	The sdo_geometry value to be converted.

Returns

Return	Description
`CLOB`	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