37.27 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
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;
Parent topic: APEX_JSON