Re: Help : ORA-00604 & ORA-01000

From: Scott Niese <nieses_at_nospamok.westfaro.com>
Date: Fri, 20 Apr 2001 23:59:42 -0400
Message-ID: <3ae106af$0$42883$f92e4de5@news.stratos.net>

Short of tuning your SQL statements, you'll have to keep increasing the maximum cursor attribute in the init file. I've encountered this problem trying to delete from a table with many fk constraints referencing it. In that case, the only thing to do is increase the maximum number of cursors available to a session.

Scott

Westfaro Corporation
www.westfaro.com
Development Tools for Developers

AT <adrianting_at_post1.com> wrote in message news:3ae0e4b5$1_at_news.starhub.net.sg...
> Hi everyone
>
> I am currently getting the following exception from my Oracle 8i. It seems
> pretty random and although I've increased the open cursor attribute in the
> init file to 200, stopped and restarted the server, it is still occuring
> (but at a lesser frequency).
>
> I've also ensured that all the sql statements are closed appropriately.
>
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01000: maximum open cursors exceeded
>
> Is there anyone who faces this similar problem and has found a better
> solution?
>
> Cheers,
> Adrian Ting
>
>
Received on Fri Apr 20 2001 - 22:59:42 CDT