can we fetch cursor even after closing it

rajivtechno · New User Joined: 05 Apr 2005 Posts: 17 Location: chennai

can we fetch cursor even after closing

sivatechdrive · Posted: Mon Apr 25, 2005 11:58 am Post subject:

Hi Friend

no, we cannot fetch after the cursor is closed
the procedure is Declare-open-fetch-close

regards
siva

shymalasridevi · New User Joined: 03 May 2005 Posts: 16

we can open the cursor any no of times in a program
but before opening if it is opend we have to close the cursor
bye

kanak · Moderator Joined: 12 Mar 2005 Posts: 260 Location: India

cursor is nothing but a memory location where the query result are stored, so that you can perform some amthematical operation on the fetched valued, simple select won't let you to perform any operation on the element fetched.So when you perform close cursore , it is nothing but it realses that memory location.So after closing you can't fetch any more records.