Register now or log in to join your professional community.
you can Close the cursor. for example : CLOSE employees_cur;
Thanks for the invitation. Its been long time I was into the industry, so totally out of touch. But let me try to answer what ever I can try to recollect as it is my interests.
once you fetched the data into your CURSOR, you might wanna store the data into RECORD TYPE array structure to make use it in local purpose within a LOOP.
once you done the above you can CLOSE THE CURSOR, if in between the loop i think you can BREAK.
Not very sure as I already mentioned its been 15 years now that I was worked on ORACLE and now totally out of touch.
Any ways I request you to throw some light on it so that I can refresh as well. Thanks.