Error: PLS-00103: Encountered the symbol "CREATE"_JAVA_编程开发_程序员俱乐部

中国优秀的程序员网站程序员频道CXYCLUB技术地图
热搜:
更多>>
 
您所在的位置: 程序员俱乐部 > 编程开发 > JAVA > Error: PLS-00103: Encountered the symbol "CREATE"

Error: PLS-00103: Encountered the symbol "CREATE"

 2013/8/30 19:09:18  FJJJ8  程序员俱乐部  我要评论(0)
  • 摘要:Error:PLS-00103:Encounteredthesymbol"CREATE"Ifyoucreatepackageandencounteredaboveerror,pleaseadd/asbelowshow.CREATEORREPLACEPACKAGETEMPLATE1ISTYPEARR_SEQISVARRAY(100)OFVARCHAR2(200);FUNCTIONFUN_CREATE_PROJECT_ID(IN_NINNUMBER)RETURNARR_SEQ
  • 标签:
Error: PLS-00103: Encountered the symbol "CREATE"

If you create package and encountered above error, please add / as below show.

class="java">CREATE OR REPLACE PACKAGE TEMPLATE1 IS

  TYPE ARR_SEQ IS VARRAY(100) OF VARCHAR2(200);

  FUNCTION FUN_CREATE_PROJECT_ID(IN_N IN NUMBER) RETURN ARR_SEQ;

END TEMPLATE1;
/

CREATE OR REPLACE PACKAGE BODY TEMPLATE1 IS

  FUNCTION FUN_CREATE_PROJECT_ID(IN_N IN NUMBER) RETURN ARR_SEQ AS
    N         NUMBER;
    I         NUMBER;
    V_VAL     VARCHAR2(200);
    V_ARR_SEQ ARR_SEQ;
  BEGIN
    N         := NVL(IN_N, 0);
    I         := 1;
    V_ARR_SEQ := ARR_SEQ();
    LOOP
      EXIT WHEN N <= 0;
      SELECT SEQ_AUTO_ID.nextval INTO V_VAL FROM DUAL;
      V_ARR_SEQ.EXTEND;
      V_ARR_SEQ(I) := V_VAL;
      N := N - 1;
      I := I + 1;
    END LOOP;
    RETURN(V_ARR_SEQ);
  END FUN_CREATE_PROJECT_ID;
END TEMPLATE1;
  • 相关文章
发表评论
用户名: 匿名