Re: ORA-00604

[Quoted] Hi, Vadim:

This is an internal error, and thus cannot be fixed. You need to contact Oracle support. A fix may already exist for this problem.

                                           Rick

Vadim Grepan <kezal_at_mail.ru> writes:

> 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
>
>

-- 
                                Rick Wessman
                                Security Assurance Group
                                Oracle Corporation
                                Rick.Wessman_at_oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.