create or replace function tq84_o(j clob) return number as jsn json_object_t; begin jsn := json_object_t.parse(j); return jsn.get_number('num'); end tq84_o; / begin dbms_output.put_line(tq84_o(' { "num": 42, "txt": "hello\world" -- Note the backslash } ')); end; /