ORA-00604
Date: Tue, 18 Dec 2001 11:06:07 +0300
Message-ID: <3C1EF8EF.F0A8C6DB_at_mail.ru>
[Quoted] Hello All!
Sometimes I've got ORA-00604 while do connect from remote application via Net8. I wonder but no any record in alert.log concerning it. I've set event = "604 trace name errorstack level 10" and detected the following lines in alert.log:
- cut === ... ksedmp: internal or fatal error ORA-00604: error occurred at recursive SQL level 1 ORA-00001: unique constraint (.) violated ORA-00001: unique constraint (CTXSYS.SYS_IOT_TOP_24317) violated ...
- cut ===
The corresponding .trc-file keeps simplest UPDATE-clause like
=== cut ===
UPDATE tbl_msg SET user_id=1128, msg_pages=284, data_type_id=1,
WHERE msg_id=10028501;
=== cut ===
Moreover I can successfully execute that clause from SQL*Plus e.g.
Next i've checked constrant
=== cut ===
SQL> select OWNER, TABLE_NAME, TABLE_TYPE from dba_indexes
2 where INDEX_NAME='SYS_IOT_TOP_24317';
OWNER TABLE_NAME TABLE_TYPE
------------------------- ------------------------- -----------CTXSYS DR$PENDING TABLE
=== cut ===
AFAIK it's the internal CTXSYS's table. How can I fix that violation?
Rgds, Vadim Grepan
Moscow, Russia
email: kezal(_at_)mail.ru Received on Tue Dec 18 2001 - 09:06:07 CET