Re: TOO_MANY_ROWS

[Peter Brawley]

Your exception handler has multiple lines so it needs begin...end:

  declare EXIT handler for SQLEXCEPTION 
    begin
      SET has_error=1;
      select 'TOO MANY ROWS';
    end;