`

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

阅读更多
Error: PLS-00103: Encountered the symbol "CREATE"

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

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;
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics