When you encounter the following issue when creating a trigger :
Error report –
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kqlidchg0], [], [], [], [], [], [], [], [], [], [], []
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated
00603. 00000 – “ORACLE server session terminated by fatal error”
*Cause: An Oracle server session was in an unrecoverable state.
*Action: Log in to Oracle again so a new server session will be created
automatically. Examine the session trace file for more
information.
Try the following solutions :
ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS:NONE';
Or in Oracle SQL Developer:
- Go to Tools | Preferences
- Select Database | PL/SQL Compiler
- Change the PLScope identifiers from All to None
- Click on Ok
2 comments
It would be great if you can explain why this error ocurred ?
Hi Shailendra, it seems that there is already a identifier present in de pl/scope with the same name. Sql developer initiates sessions with identifiers on. Toad and sql plus do not. So turning this off in Sql developer solves this issue. You can query the identifiers by selecting from all_identifiers.