-- Oracle 19c: Parse JSON text to get values  

SET SERVEROUTPUT ON;

DECLARE
 jobj   JSON_OBJECT_T;
 jobjn  JSON_OBJECT_T;

BEGIN
 jobj := JSON_OBJECT_T.parse('{msg:"Hello"}');
 jobj.On_error(1);

 jobjn := JSON_OBJECT_T.parse('{"Price":100.00}');
 jobjn.On_error(1);

 DBMS_OUTPUT.PUT_LINE(jobj.get_String('msg'));
 DBMS_OUTPUT.PUT_LINE(jobjn.get_Number('Price'));

 --This will result in error
 --DBMS_OUTPUT.PUT_LINE(jobj.get_Number('msg'));  
END;
/