Help on ORA-00604
Date: Thu, 1 Feb 2001 17:46:20 -0500
Message-ID: <95covu$moc1_at_biko.telecom.ups.com>
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.
The following is the top few entries the oracle trace file.
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.
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
Received on Thu Feb 01 2001 - 23:46:20 CET