TOO_MANY_ROWS

[pradeesh Joseph]

Dear Experts,

I am newbie to MYSQL

please help to return too_many_rows in mysql when procedure more than one row.

tried proc.

create or replace procedure TOO_MANY_ROWS
(in ENAME varchar(255))
begin
DECLARE VALUE_RETURN VARCHAR(255);
declare exit handler for 1062 select 'TOO MANY ROWS';
select bt.name INTO VALUE_RETURN from employees bt inner join dept ec
on bt.id=ec.it
where ENAME=V_NAME;
END;

Error:

Declare VA AT LINE1