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

[Roland Bouman]

CREATE OR REPLACE FUNCTION DESC2RPT000105_FUNC (
INRPT101ID VARCHAR(put the length here)
, INRPT104ID VARCHAR(put the length here)
)
RETURNS VARCHAR(put the length here)
begin
declare MYCURSOR CURSOR FOR
SELECT DESCRIPTION
FROM RPT000105
WHERE RPT000101ID = INRPT101ID
AND RPT000104ID = INRPT104ID
AND STRIP <> 'Y'
;
declare VRET VARCHAR(500);
declare description VARCHAR(500);
declare done bool default false;
declare continue handler for not found set done := true;

set VRET := '';
open MYCURSOR;
LOOP_MYCURSOR: loop
fetch MYCURSOR
into description
;
if done then
close MyCURSOR;
if vret <> '' then
set vret := left(VRET,character_length(vret)-1);
end if;
leave LOOP_MYCURSOR;
end;
set vret := concat(vret,rtrim(description),'/');
end loop;
RETURN vret;
END;