January 14th, 2004, 02:06 AM
Join Date: Nov 2003
Time spent in forums: 3 h 12 m 17 sec
Reputation Power: 10
Too Many Cursors Error
I am using two types of cursors in my System Oracle 9i. One is a "For" Cursor and Other Cursor is a dbms.type Cursor as given below.
stmt_str:='truncate table dup_bob';
Even though all the Cursors are closed... Sometimes (One in 3-4 Months) it gives the following
"ERROR Occured at ORA-00604 Error Occured at recursive SQL Level ORA-01000 Maximum Open Cursor Exceeded"
I have checked all the Procedures thoroughly for any open cursors but there are none.
Does "For" Cursors have to be manually Closed??? Also What Happens When There is an Exception in the For Cursor that are Not handled, Does the Cursor remain open???