Home » SQL & PL/SQL » SQL & PL/SQL » Update Statement Error
Update Statement Error [message #19232] Wed, 06 March 2002 07:54 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 #19243 is a reply to message #19232] Wed, 06 March 2002 11:12 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
are u using dbms_sql package inside pl/sql block?
Re: Update Statement Error [message #19263 is a reply to message #19243] Thu, 07 March 2002 05:36 Go to previous message
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.
Previous Topic: Rowid
Next Topic: Closed Cursor query in procedure - listed in v$open_cursor
Goto Forum:
  


Current Time: Tue Oct 19 20:09:02 CDT 2021