Re: Help on ORA-00604

open_cursors=100 isn't very much - set it to 2, or 300. Will not use resource or space when not used (well, hardly), so doesn't harm when set too high.

Bigfoot wrote:

> I am running a C program which calls lots of Pro*C modules.
> Sometime the execution completes successfuly and some time
> and I get "ORA-00604: error occurred at recursive SQL level 1"
> error.
> I reviewed all my Pro*C programs to confirm all the cursors are closed
> before opening another cursor.
> The OPEN_CURSORS parameter is set to 100.
> I am 100% sure that I am not opening those many cursors at one time.
> Can some please help me how to debug this problem and correct it.
>
> The following is the top few entries the oracle trace file.
>
> *** SESSION ID:(28.3569) 2001.01.26.09.50.00.619
> kgefec: fatal error 0
> *** 2001.01.26.09.50.00.679
> ksedmp: internal or fatal error
> ORA-00603: ORACLE server session terminated by fatal error
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01000: maximum open cursors exceeded
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01000: maximum open cursors exceeded

--
Gtrz,

Frank van Bortel