Sometime we’d like to trigger ORA-00600/7445 internal errors for testing purpose, But it’s not easy if you don’t know a little trick like below:
declare a exception; pragma exception_init(a,-600); begin raise a; end; declare * ERROR at line 1: ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], [] ORA-06512: at line 5 or oradebug unit_test dbke_test dde_flow_kge_ora ouch! 0 0 7445: select spidfrom v$processp, v$sessions where p.addr= paddr and sid= sys_context('USERENV','SID'); kill -SEGV $PID or declare a exception; pragma exception_init(a,-7445); begin raise a; end;
Comment