17,089
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE FUNCTION "PROJECTPLANACTORS"
(sProjectID in varchar2,sActionID in varchar2)
return varchar2 as
sReturnValue varchar2(32000);
sTemp varchar2(20);
cursor cu1(p1 varchar2,p2 varchar2)
is select b.USERCNAME from pdwfd17 a inner join asreg005 b on a.Actor = b.userid
where a.procaseid=p1 and a.actionid=p2;
begin
open cu1(sProjectID,sActionID);
sReturnValue:='';
loop
fetch cu1 into sTemp;
exit when cu1%notfound;
if length(sReturnValue) > 0 then
sReturnValue:= sReturnValue || ',';
end if;
sReturnValue:=sReturnValue || sTemp;
end loop;
close cu1;
return(sReturnValue);
end ProjectPlanActors;