multiple cursors [message #37838] |
Fri, 01 March 2002 12:17 |
Sam
Messages: 255 Registered: April 2000
|
Senior Member |
|
|
Hi,
Iam having problem reading two cursors.
currently iam doing somethin like this
declare empcur cursor for
select distinct empid from emp where deptid = 100
open empcur
fetch int emp1
close empcur;
iam calling a stored procedure next to select rest of the emp information for each empid.
i have a cursor and iam fetching in
for(;;)
{
}
but iam getting only one row. i,e first empid information. not the rest.
how to get the rest of empid informations.
any help will appreciated
thanks
|
|
|
Re: multiple cursors [message #37847 is a reply to message #37838] |
Sun, 03 March 2002 23:16 |
Manoj
Messages: 101 Registered: August 2000
|
Senior Member |
|
|
hi sam,
use it
declare
cursor empcur is
select distinct empid from emp where deptid = 100;
begin
for i in empcur loop
call procedure(i.empid);
end loop;
end;
|
|
|
|