[20230108]ORA-00600 and Session Disconnected.txt

[20230108]ORA-00600 and Session Disconnected.txt

--//http://ksun-oracle.blogspot.com/2022/07/plsql-ora-00600-by-jdbc-call-exception.html

--//測試:ORA-00600 and Session Disconnected

1.環境:
SCOTT@test01p> @ver1
PORT_STRING                    VERSION        BANNER                                                                               CON_ID
------------------------------ -------------- -------------------------------------------------------------------------------- ----------
IBMPC/WIN_NT64-9.1.0           12.2.0.1.0     Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production              0

2.測試指令碼:
--//drop table test_tab_disconnet;

create table test_tab_disconnet(id number, label varchar2(10));
insert into test_tab_disconnet(id, label) values(1, 'label');
commit;

create or replace procedure test_ora_600_disconnet as
begin
  savepoint sp;
  update test_tab_disconnet set label = label where id = 1;
  execute immediate '
    begin
      raise_application_error(-20000, ''error-sp'');
    exception
      when others then
        rollback to savepoint sp;
        update test_tab_disconnet set label = label where id = 1;
        raise;
    end;';
end;
/

3.測試:
SCOTT@test01p> exec test_ora_600_disconnet
BEGIN test_ora_600_disconnet; END;

*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [4156], [], [], [], [], [], [], [], [], [], [], []
ORA-20000: error-sp
ORA-06512: at line 8
ORA-06512: at line 3
Process ID: 5376
Session ID: 170 Serial number: 51363