Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Force Oracle to close the cursor after executing PL/SQL

389709Mar 10 2003 — edited Mar 17 2003
I 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...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2003
Added on Mar 10 2003
10 comments
1,092 views