26.26 PARSE Procedure Signature 1

This procedure parses a JSON-formatted varchar2 or clob and puts the members into p_values.

Syntax

APEX_JSON.PARSE (
    p_values   IN OUT NOCOPY t_values,
    p_source   IN VARCHAR2,
    p_strict   IN BOOLEAN DEFAULT TRUE );

APEX_JSON.PARSE (
    p_values   IN OUT NOCOPY t_values,
    p_source   IN CLOB,
    p_strict   IN BOOLEAN DEFAULT TRUE );

Parameters

Table 26-33 PARSE Procedure Parameters

Parameter	Description
p_values	An index by varchar2 result array which contains the JSON members and values. The default is g_values.
p_source	The JSON source (varchar2 or clob)
p_strict	If TRUE (default), enforce strict JSON rules

Example

This example parses JSON and prints member values.

DECLARE
    l_values apex_json.t_values;
BEGIN
    apex_json.parse (
        p_values => l_values,
        p_source => '{ "type": "circle", "coord": [10, 20] }' );
    sys.htp.p('Point at '||
        apex_json.get_number (
            p_values => l_values,
            p_path   => 'coord[1]')||
        ','||
        apex_json.get_number (
            p_values => l_values,
            p_path   => 'coord[2]'));
END;