15.23 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 15-25 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;