Re: ORA-00604 error occurred at recursive SQL level num

Costin Rizan wrote:
>
> Hello,
>
> I'm getting this error in one of my forms once in a while. As far
> as I can tell this error might have something to do with a table
> constraint violoation however due to the number of tables involved and
> the fact that the error does not happen all the time, I am havine trouble
> pin pointing the problem.
>
> Would somebody that has encountered this error before, confirm
> that this type of error may indeed be a constraint violation and if so,
> how can I find out which constraint?
>
> Thanks!
>
> Costin

We encountered this error many times on one of our laptops. We found SGA was being exhausted, and cursors were not opening and closing properly. We added RAM and bumped up the SGA, the problem went away.

Good Luck. Received on Mon Jun 09 1997 - 00:00:00 CEST