Re: TOO_MANY_ROWS

[pradeesh Joseph]

Thanks for your reply.

After changing to create only.

i am getting SQL ERROR: Error Executing Query, Please check.

create procedure TOO_MANY_ROWS
(in ENAME varchar(255))
begin
declare EXIT handler for SQLEXCEPTION SET has_error=1;
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;