View previous topic :: View next topic
|
Author |
Message |
rajivtechno
New User
Joined: 05 Apr 2005 Posts: 17 Location: Bangalore
|
|
|
|
can we fetch cursor even after closing |
|
Back to top |
|
|
sivatechdrive
Active User
Joined: 17 Oct 2004 Posts: 191 Location: hyderabad
|
|
|
|
Hi Friend
no, we cannot fetch after the cursor is closed
the procedure is Declare-open-fetch-close
regards
siva |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
kanak
Moderator
Joined: 12 Mar 2005 Posts: 252 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. |
|
Back to top |
|
|
|