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 found set y=1;
create temporary table
insert into temporary table
open c1
(c1 will join table a and temp table to get the result)
close c1
open c2
(c2 will join table b and temp table to get the result)
close c2
end
On Feb 11, 2008 11:08 AM, Paul DuBois <[EMAIL PROTECTED]> wrote:
>
> 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 contine handler for not found set y=1;
> >
>
> http://dev.mysql.com/doc/refman/5.0/en/cursors.html:
>
> "Cursors must be declared before declaring handlers. Variables and
> conditions must be declared before declaring either cursors or
> handlers."
>
> You have a handler declared before a cursor.
>
> --
> Paul DuBois, MySQL Documentation Team
> Madison, Wisconsin, USA
> MySQL AB, www.mysql.com
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
