Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1414
  • Last Modified:

ORA-00600 Error

Hi, I am pretty new to Oracle, but I am just trying to run a simple delete statement:

DELETE  FROM MEMBER_ELIG_HISTORY
WHERE            update_datetime
BETWEEN        TO_DATE('04/25/2006 09:06:35', 'mm/dd/yyyy HH:MI:SS PM')
AND                TO_DATE('04/26/2006 12:21:06', 'mm/dd/yyyy HH:MI:SS AM')


I keep getting this error:
ORA-00600: internal error code, arguments: [4097],[],[],[],[],[],[],[]

I am running the delete statement in TOAD for Oracle 8i.

 Thanks in advance.

0
asombill
Asked:
asombill
  • 2
  • 2
1 Solution
 
Mark GeerlingsDatabase AdministratorCommented:
Your problem may be a mismatch between your format mask (which includes: " PM" at the end) and your data value, which does not, so try this (with no " PM" or " AM"):
DELETE  FROM MEMBER_ELIG_HISTORY
WHERE            update_datetime
BETWEEN        TO_DATE('04/25/2006 09:06:35', 'mm/dd/yyyy HH:MI:SS')
AND                TO_DATE('04/26/2006 12:21:06', 'mm/dd/yyyy HH:MI:SS')

or this (with "AM" or "PM" on your data to match the format mask):
DELETE  FROM MEMBER_ELIG_HISTORY
WHERE            update_datetime
BETWEEN        TO_DATE('04/25/2006 09:06:35 PM', 'mm/dd/yyyy HH:MI:SS AM')
AND                TO_DATE('04/26/2006 12:21:06 AM', 'mm/dd/yyyy HH:MI:SS AM')

If one of those works, I'm a bit surprised because usually an error in a format mask for "to_date" is handled more gracefully than that.  An ORA-00600 error usually indicates a serious problem.  If you still get the ORA-00600 error, you will have to check the alert.log file on the server for more info, and you may need to get Oracle Technical Support involved.  Basically an ORA-00600 error is any unexpected condition that Oracle can not handle gracefully.
0
 
asombillAuthor Commented:
Thank you for your response. I did attempt a search on Metalink, to no avail. It is just strange to me, as when I performed the same select statement, there was no error, so I thought the delete statement would follow suit. I will try again tomorrow and post my results.

Thanks,
Allan
0
 
Mark GeerlingsDatabase AdministratorCommented:
Your select statement worked with a mis-match between the data you provided for "to_date" and the format mask you provided?
I doubt that!

I suspect that in your select statement, your data matched your format mask!
0
 
mohammadzahidCommented:
Hi,

I was not able to reproduce your error in 9i (9.2.0.6). I think you are running into some Oracle bug that is returning Ora-00600 in Oracle 8i.

Here is what I did to reproduce your error:

create table update_table
(col1 date);

insert into update_Table
values(to_date('04/24/2006 09:06:35','mm/dd/yyyy HH:MI:SS PM'))
/
insert into update_Table
values(to_date('04/26/2006 10:06:35','mm/dd/yyyy HH:MI:SS PM'))
/
insert into update_Table
values(to_date('04/27/2006 11:06:35','mm/dd/yyyy HH:MI:SS PM'))
/

DELETE  FROM update_table
WHERE   col1
BETWEEN TO_DATE('04/25/2006 09:06:35', 'mm/dd/yyyy HH:MI:SS PM')
AND     TO_DATE('04/26/2006 12:21:06', 'mm/dd/yyyy HH:MI:SS AM')

>> Result 2 rows deleted.

I deleted these rows in TOAD and in SQLPLus same result.

Good luck!!

0
 
mohammadzahidCommented:
First insert data is
insert into update_Table
values(to_date('04/25/2006 09:06:35','mm/dd/yyyy HH:MI:SS PM'))  

not
insert into update_Table
values(to_date('04/24/2006 09:06:35','mm/dd/yyyy HH:MI:SS PM'))

Sorry about the error.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now