Oracle Store procedure error handling json file
DECLARE
CURSOR species_cur
IS
SELECT id, sp.info
FROM json_species sp;
l_info json_element_t;
l_document_object json_object_t;
l_name json_element_t;
BEGIN
FOR rec IN species_cur
LOOP
l_info := json_element_t.parse (rec.info);
l_document_object := TREAT (l_info AS json_object_t);
l_name := l_document_object.get ('name');
dbms_output.put_line (l_name.to_string);
end loop;
END;
/