Joined: 06 Dec 2004 Posts: 211 Location: Keane Inc., Minneapolis USA.
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.