Re: How to convert this Oracle PL/SQL Function to MySQL

[anupam tripathi]

YOU can try this

create function desc2rpt000105_func (rpt101id varchar(225),inrpt104id varchar(225) )returns varchar(225)
begin
declare mycursor cursor for select description from rpt000105 where rpt000101id = inrpt101id and rpt000104id = inrpt104id and strip <> 'y';
declare vret varchar(500);
set vret = '';
for vperrow in mycursor loop
set description)||'/';
end loop;
return rtrim(vret,'/');
end;