Search notes:

Oracle Event 10928

Event 10928 controls if tracing of all executed PL/SQL pseudo codes is enabled.
Create a simple demonstration function:
-- drop   function tq84_f;
create function tq84_f(n integer) return number authid definer as
begin
   if n > 5 then
      return 2 * n;
   end if;
   return 3 * n;
end tq84_f;
/

-- alter function tq84_f compile debug;
Enable tracing
alter session set events '10928 trace name context level 1';
-- alter session set events '10938 trace name context level 5';
Exeecute the function:
begin
   dbms_output.put_line(tq84_f(3));
end;
/
Show the data in the trace file.
select
   trc.payload,
   trc.timestamp
from
   v$diag_info inf   join
   v$diag_trace_file_contents  trc on regexp_replace(inf.value, '.*[\\/]', '') = trc.trace_filename
where
   inf.name = 'Default Trace File'
order by
   trc.line_number
;

See also

See also Event 10938
MOS Note 52481.1
Pete Finnigans blog

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