OraFAQ Forum: Forms » Error ORA-00600

Home » Developer & Programmer » Forms » Error ORA-00600

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

Error ORA-00600 [message #637880]

Thu, 28 May 2015 04:43

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

Hello guys,
I have created a form and I wanted to check a table name so,
inside a button trigger I used this command

select tname into x from tabs
where tname like('%1111%');

I am getting this error :
ora-00600: internal error code arguments: [17069] ,[84498400],,,,,,,

I am using Oracle developer 6i

Report message to a moderator

Re: Error ORA-00600 [message #637883 is a reply to message #637880]

Thu, 28 May 2015 04:56

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

ORA-00600 indicates a bug which should be discussed with Oracle Support. However, as Developer 6i is out of support for quite a while now, you're most probably out of luck (if you plan to talk to them).

Therefore, let us try to help you.

Which database version do you use? Operating system?

Does that SELECT statement runs correctly when you execute it in SQL*Plus? If so, create a (database, stored) function and call it from your form.

Report message to a moderator

Re: Error ORA-00600 [message #637884 is a reply to message #637880]

Thu, 28 May 2015 05:00

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

Senior Member
Account Moderator

Even it is no more supported you can search on Metalink/MOS to see if this not a known bug and if there is a workaround.

Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.

Report message to a moderator

Re: Error ORA-00600 [message #637886 is a reply to message #637884]

Thu, 28 May 2015 05:08

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

Which database version do you use? Operating system?
I am using 10g Database on Windows 8
Does that SELECT statement runs correctly when you execute it in SQL*Plus? If so, create a (database, stored) function and call it from your form.
Yes It does.

Report message to a moderator

Re: Error ORA-00600 [message #637888 is a reply to message #637886]

Thu, 28 May 2015 05:11

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

So, did you create a function and used it in a form? What happened?

Report message to a moderator

Re: Error ORA-00600 [message #637891 is a reply to message #637888]

Thu, 28 May 2015 05:48

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

I wrote it in a button trigger to check a name of table because I want to use the table name.


declare 
x varchar2(50) ; 
begin 
select tname into x 
from tabs
where tname like (%1111%) ; 
if x is null 
then message('NO such table exist') ; 
end if ;

[Updated on: Thu, 28 May 2015 05:50]

Report message to a moderator