Re: 2 cursors in a store procedure

Thanks for your reply. Actually, I want to do the following. But I have no idea how to do it. create procedure a() begin declare ... declare c1 cursor for select ... declare contine handler for not found set x=1; declare c2 cursor for select ... declare contine handler for not fou

Re: 2 cursors in a store procedure

At 10:57 AM +0800 2/11/08, Rilawich Ango wrote: HI all, How can a store procedure to contain 2 cursors? Any advise? ango create procedure a() begin declare ... declare c1 cursor for select ... declare contine handler for not found set x=1; declare c2 cursor for select ... declare

2 cursors in a store procedure

HI all, How can a store procedure to contain 2 cursors? Any advise? ango create procedure a() begin declare ... declare c1 cursor for select ... declare contine handler for not found set x=1; declare c2 cursor for select ... declare contine handler for not found set y=1; -- M