oracle 自定义function

CREATE OR REPLACE FUNCTION FUN_GET_LINK_SPECIFY_ADMINS(P_LINK_ID IN NUMBER)
RETURN VARCHAR2 AS
  /*获取指定链接定向所有管理员名字，拼装成字符串输出
   @CREATEDATE 2009-05-11
   @AUTHOR LUJUN
  */

  V_RETURN VARCHAR2(4000) := '';
  V_ADMIN_NAME VARCHAR2(30);
  CURSOR CUR IS
   SELECT ADMIN_NAME FROM TBL_LINK_SPECIFY_ADMIN WHERE LINK_ID=P_LINK_ID;
BEGIN

  OPEN CUR;
  LOOP
      FETCH CUR INTO V_ADMIN_NAME;
      EXIT WHEN CUR%NOTFOUND;
      V_RETURN :=(V_RETURN || ' ' || V_ADMIN_NAME);

  END LOOP;

  RETURN(V_RETURN);
END FUN_GET_LINK_SPECIFY_ADMINS;