declare l_json varchar2(4000):='{"questionnaires":[{"section":"data"}]}'; l_json_path varchar2(4000):='$.questionnaires[0].section'; begin dbms_output.put_line( json_value(l_json, l_json_path) ); end;
The PL/SQL code is correct and executes successfully.
Thanks. I see this and will log it.