Update Statement Error [message #37920] |
Wed, 06 March 2002 07:50 |
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.
|
|
|
|