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;
....

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to