ORACLE server session terminated by fatal error

oracle triggers oracle11g ora-00600
Bishan picture Bishan · Feb 28, 2013 · Viewed 8.7k times · Source

I have edited a Trigger and try to save. then i got below error.

Error: ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kqlidchg1], [], [], [], [], [], [], [], [], [], [], []
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated

i can't save my trigger with modifications. how can i solve this ?

Answer

The Camster picture The Camster · Jun 6, 2013

I repeatedly got this error list creating a Trigger:

ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kqlidchg1], [], [], [], [], [], [], [], 
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"

In SQLDeveloper, edit the PLSCOPE_SETTINGS:

Tools->Preferences ->Database->PL/SQL Compiler

Set "PLScope identifiers:" to "None" This fixed the problem and I had no issues after this.

Related questions

pragma autonomous_transaction in a trigger

I have written a trigger on one table which deletes data from other table upon a condition. The trigger has pragma autonomous_transaction, and trigger works as intended. However, I do wonder if there can be any problems in future, …

Read More
PLSQL :NEW and :OLD

Can anyone help me understand when to use :NEW and :OLD in PLSQL blocks, I'm finding it very difficult to understand their usage.

Read More
ORA-04082: NEW or OLD references not allowed in table level triggers

itI have table named per. In the per table, I have a field named "fl1" and another field named "fl2". When updating a record, I want to check if the value of "fl1" has changed". If the value has changed, …

Read More