Home » Developer & Programmer » Forms » Error ORA-00600
Error ORA-00600 [message #637880] Thu, 28 May 2015 04:43 Go to next message
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
Re: Error ORA-00600 [message #637883 is a reply to message #637880] Thu, 28 May 2015 04:56 Go to previous messageGo to next message
Littlefoot
Messages: 21690
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.
Re: Error ORA-00600 [message #637884 is a reply to message #637880] Thu, 28 May 2015 05:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68043
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Error ORA-00600 [message #637886 is a reply to message #637884] Thu, 28 May 2015 05:08 Go to previous messageGo to next message
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.
Re: Error ORA-00600 [message #637888 is a reply to message #637886] Thu, 28 May 2015 05:11 Go to previous messageGo to next message
Littlefoot
Messages: 21690
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So, did you create a function and used it in a form? What happened?
Re: Error ORA-00600 [message #637891 is a reply to message #637888] Thu, 28 May 2015 05:48 Go to previous messageGo to next message
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

Re: Error ORA-00600 [message #637892 is a reply to message #637891] Thu, 28 May 2015 06:09 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
You need to create a function in the DB and then call that from the form.
Re: Error ORA-00600 [message #664487 is a reply to message #637892] Thu, 20 July 2017 01:51 Go to previous message
amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia
Senior Member
Thank You. Problem solved.
Previous Topic: Auto Generate for a serial Number Field
Next Topic: Problem with adding and updating
Goto Forum:
  


Current Time: Wed Dec 01 22:26:17 CST 2021