| Update Statement Error [message #19232] |
Wed, 06 March 2002 07:54  |
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 #19263 is a reply to message #19243] |
Thu, 07 March 2002 05:36  |
Ferenc Csuk
Messages: 3
Registered: March 2002
|
Junior Member |
|
|
|
yes, I'm. I thought I might have to try dynamic sql with "execute immediate", but I haven't tried it yet. Ist the dbms_sql package the cause of the fault? But what strange is, that then, when it happened, I let the pl/sql block write the sql update command and the value of the bind variables to the screen, and I executed it in an other sqlplus window, and I got the same error code.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
