More than one cursor at a time

smgaru · New User Joined: 05 Apr 2005 Posts: 5 Location: Hyderabad

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.

Will be waiting for answer....

smgaru

ovreddy · Posted: Wed Apr 06, 2005 11:41 am

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.

Thanks for your good question,
Reddy.

ajaychandra · New User Joined: 31 Mar 2005 Posts: 16 Location: Bangalore

Dear Friend,

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.

Any Suggestions are welcome.........

Ajay Chandra

learnmf · Active User Joined: 14 Mar 2005 Posts: 123

poolarajesh · New User Joined: 22 Jan 2004 Posts: 4

Hi,

We can use both cursors at a time by specifying ?WITH UR? option.

Rajesh