Search notes:

ORA-40472: invalid escape in JSON data

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;
/

See also

ORA-40441: JSON syntax error
Other Oracle error messages

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759473800, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/errors/ORA-40472_invalid-escape-in-JSON-data(56): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78