29.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 29-45 STRINGIFY Parameters

Parameter	Description
p_value	The date value to be converted.

Returns

Table 29-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;