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 |
---|---|
|
An index by |
|
The JSON source ( |
|
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