OraFAQ Forum: Client Tools » Unable to comiple the triggers

Home » Other » Client Tools » Unable to comiple the triggers (Oracle Sql Developer Version 1.5.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to comiple the triggers [message #574798]

Tue, 15 January 2013 22:04

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

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.

Report message to a moderator

Re: Unable to comiple the triggers [message #574812 is a reply to message #574801]

Wed, 16 January 2013 00:26

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 00:41:11 CST 2025