Re: TOO_MANY_ROWS

[pradeesh Joseph]

Thanks peter for your reply.

Please help to resolve this

create procedure TOO_MANY_ROWS
(in V_NAME varchar(255))
begin
DECLARE VALUE_RETURN VARCHAR(255);
begin
SET has_error=1;
select 'TOO MANY ROWS';
end;
select bt.name INTO VALUE_RETURN from employees bt inner join dept ec
on bt.id=ec.it
where ENAME=V_NAME;
END;


Error :

SQL ERROR: Error Executing Query, Please check.