Force Oracle to close the cursor after executing PL/SQL
389709Mar 10 2003 — edited Mar 17 2003I believe after execution of each PL/SQL statement by using implicit cursor, oracle stores the cursor in the private SQL area.
I came to know that setting init parameter close_session_cached_cursors to yes will release cursor after executing the statement.
But, i found that parameter is deprecated in 8i. I also came to know that in Oracle 8i Algorithm is changed and so there is no need for that anymore. If more cursors have to be allocated, oracle will do so by removing the existing one.
But, I some how want to force Oracle not to cache the cursor after executing PL/SQL statement. how to do that?
Since, i think this is the reason for getting ORA-01000 Maximum cursors error in running our application.
Note: I don't want to increase the OPEN_CURSORS parameter in init.ora file.
Please Help...