Hi,
Can we declare and open more than one cursor at a time for the same table. At the same time can we fetch one row by using select statemnet when the cursor is already opened for the same table.
Joined: 06 Dec 2004 Posts: 200 Location: Keane India Ltd., Hyderabad
Hi SMGaru,
I never tried this multiple cursor situation. But Surely I am confident that Multiple cursor senario will work. Because Assume 2 Procedures using the cursors on same table. We can call them simultaniously. So it will work.
Your second question, when a cursor is opened on a table then a select will fetch the rows normally. This i tried many times and worked. Try multiple cursor senario and let us know the results.
Multiple cursors can be decleared for the same table.
Assume T is the Table name then T can have more than one cursor decleared on it. Say C1 and C2 are the cursors decleared on T. Initially if cursor C1 is opened, C2 cannot be opened untill the cursor C1 is closed. Hense you cannot fetch data at the same time.
Hi,
Can we declare and open more than one cursor at a time for the same table. At the same time can we fetch one row by using select statemnet when the cursor is already opened for the same table.
HI FRiend
IT can posssible to declare more then one cursor at a time.
