取出角色关联的菜单ids("#_拼接")

create or replace function njutec_getMenuIds(trdids in varchar2) return varchar2 is
Result varchar2(4000);
v_acc_nbr varchar2(400);
type ref_cursor is ref cursor;
menu_id ref_cursor;
begin
Result:='';
open menu_id for
select t.menuid from PLT_MENU_ROL t
where t.trdid =trdids;
loop
fetch menu_id into v_acc_nbr;
exit when menu_id%notfound;
--if(tempCount>8) then
-- goto label_end;
--end if;
Result:=Result||'#_'||(v_acc_nbr);
end loop;
--<<label_end>>
close menu_id;
Result:=substr(Result,3,length(Result));
return(Result);
exception when others then
if(menu_id%isopen) then
close menu_id;
end if;
return '';
end njutec_getMenuIds;