原Oracle函数
create or replace FUNCTION "GET_ADMINDEPTIDS"
(
adminid IN NUMBER
) RETURN VARCHAR2 AS
v_sql varchar2(500);
v_deptids varchar(4000);
type v_avarchar2_type is record (
thevalue number
);
v_avarchar2 v_avarchar2_type;
TYPE i_cursor_type IS REF CURSOR;
c i_cursor_type;
BEGIN
v_sql := 'select deptid from admindept
where adminid = ' || adminid;
v_deptids := '';
open c for v_sql;
loop
fetch c into v_avarchar2;
exit when c%notfound;
v_deptids := v_deptids || v_avarchar2.thevalue || ',';
end loop;
close c;
RETURN substr(v_deptids, 0, length(v_deptids) - 1);
END GET_ADMINDEPTIDS;
Mysql中函数
create or REPLACE FUNCTION "GET_ADMINDEPTIDS"
(
adminid IN BIGINT
) RETURN VARCHAR
v_sql varchar(500);
v_deptids varchar(4000);
type v_avarchar2_type is record (
thevalue number
);
v_avarchar2 v_avarchar2_type;
TYPE i_cursor_type IS REF CURSOR;
c i_cursor_type;
BEGIN
v_sql := 'select deptid from admindept
where adminid = ' || adminid;
v_deptids := '';
open c for v_sql;
loop
fetch c into v_avarchar2;
exit when c%notfound;
v_deptids := v_deptids || v_avarchar2.thevalue || ',';
end loop;
close c;
RETURN substr(v_deptids, 0, length(v_deptids) - 1);
END GET_ADMINDEPTIDS;
报错: