Search notes:

Oracle Event 10397: suppress verbose parallel coordinator error reporting

The 10397 event prevents the ORA-12801: error signaled in parrallel query server … error to be put on top of the error stack which can be useful if a frontend only shows the top Oracle error (which in case of ORA-12801 is quite meaningless).
create table tq84_ora_12801 (n varchar2(50));
insert into tq84_ora_12801 select level from dual connect by level <= 1e6;
-- This is not a zero but the uppercase letter O!
insert into tq84_ora_12801 values ('O');
commit;
 
select /*+ parallel */ max(to_number(n)) from tq84_ora_12801;
-- ORA-12801: error signaled in parallel query server P005
-- ORA-01722: invalid number
 
alter session set events '10397 trace name context forever, level 1';
select /*+ parallel */ max(to_number(n)) from tq84_ora_12801;
-- ORA-01722: invalid number

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...', 1745345377, '18.191.167.79', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/adminstration/init-parameters/event/list/10397(46): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78