Skip to Main Content
Forums

SQL & PL/SQL

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!

Need clarification CURSOR memory allocation

430729Apr 13 2007 — edited Apr 13 2007
Hi All,
Pls help me to understand the below

1. I declare a cursor when the memory is going to allocated for that ,Declaration or while Opening the cursor and from which memory it is going to allocate.
2. If i close the cursor then memory is going to delocate or it is done later
3.If i close a cursor and after that i am opening it again .. IS Memory is going to allocate again ..

Thanks,
Ravi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2007
Added on Apr 13 2007
2 comments
1,198 views