Home » SQL & PL/SQL » Client Tools » Unable to comiple the triggers (Oracle Sql Developer Version 1.5.4)
icon8.gif  Unable to comiple the triggers [message #574798] Tue, 15 January 2013 22:04 Go to next message
sangeethacg123
Messages: 2
Registered: January 2013
Location: bangalore
Junior Member
hi all,

i have huge sets of triggers, when i try to compile any one of those it notifies me with below error please help me:

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

[Updated on: Wed, 16 January 2013 00:24] by Moderator

Report message to a moderator

Re: Unable to comiple the triggers [message #574799 is a reply to message #574798] Tue, 15 January 2013 22:05 Go to previous messageGo to next message
BlackSwan
Messages: 23067
Registered: January 2009
Senior Member
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

[Updated on: Tue, 15 January 2013 22:07]

Report message to a moderator

Re: Unable to comiple the triggers [message #574801 is a reply to message #574799] Tue, 15 January 2013 22:42 Go to previous messageGo to next message
sangeethacg123
Messages: 2
Registered: January 2013
Location: bangalore
Junior Member
thank you !

i found the resolution

You have to set "plscope_settings=IDENTIFIERS:NONE" in SQL-Developer (see menu EXTRAS>PREFERENCES>DATABASE>PL/SQL-COMPILER) to get rid of this error permanent. Or at least do "ALTER SESSION SET PLSCOPE_SETTINGS = 'IDENTIFIERS:NONE';" prior to execute your script.
Re: Unable to comiple the triggers [message #574812 is a reply to message #574801] Wed, 16 January 2013 00:26 Go to previous message
Michel Cadot
Messages: 59821
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is NOT a solution, it is a workaround.
The problem still remains waiting from another occasion to raise.

Regards
Michel
Previous Topic: Cannot connect to DB remotely using sqlplus
Next Topic: BR*Tools appearence not complete
Goto Forum:
  


Current Time: Fri Nov 28 15:46:46 CST 2014

Total time taken to generate the page: 0.15285 seconds