Home » SQL & PL/SQL » SQL & PL/SQL » Update Statement Error
Update Statement Error [message #37920] Wed, 06 March 2002 07:50 Go to next message
Ferenc Csuk
Messages: 3
Registered: March 2002
Junior Member
I tried to make the following update, but I got the error message ORA-00600:

DECLARE
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [[12421]], [[]], [[]], [[]], [[]], [[]], [[]], [[]]
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1118
ORA-06512: at "SYS.DBMS_SQL", line 316
ORA-06512: at line 143
ORA-06512: at line 272

The update statement was in my PL/SQL block:

UPDATE test_table SET col_c = NULL WHERE col_a = x AND col_b = y AND col_c = 0 AND col_d = z;

col_a, col_b, col_c, col_d are of type NUMBER(25).

Both on col_a and on col_b I have a compressed index on the rest nothing.

I trided to rebuild both indexes without the compression, and the same command was successfully executed.
Re: Update Statement Error [message #37963 is a reply to message #37920] Fri, 08 March 2002 21:33 Go to previous message
malarneasan
Messages: 2
Registered: March 2002
Junior Member
for this error
u have to contact
oracle customer support group
u can use this query
select * from idl_sb4$;
by connecting through sys
Previous Topic: How can I compare a string with 2 digits?
Next Topic: import data in excel sheet to oracle
Goto Forum:
  


Current Time: Thu Mar 28 15:46:31 CDT 2024