请教个sql函数问题

create or replace function SELECT_PARENT(sid in varchar2,ts in int)
return varchar2
is
result varchar2(200);
ltimes int;
ftimes int;
begin
ltimes:=ts;
ftimes:=0;
while ftimes <= ltimes
loop
if ts=0 then
result:=sid;
else
ftimes:=ftimes+1;
select ID into result from T_INVITE_SEGMENT where ID IN (SELECt PARENTID FROM T_INVITE_SEGMENT WHERe ID=sid);
end if;
exit when ftimes=ltimes;
end loop
return(result);
end SELECT_PARENT;

始终报 return(result); 这一行有错误. 错误如下:ERROR line 20, col 9, ending_line 20, ending_col 9, Found '(', Expecting: ;
请大家帮忙看下是什么错误

end loop 后面加个 " ;"
end loop -> end loop;

sql2005  有递归的cte公共表达式。

你的是什么数据库？