首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 开发语言 > Ruby Rails >

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

2013-09-13 
Error: PLS-00103: Encountered the symbol CREATEError: PLS-00103: Encountered the symbol CREATEI

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;

热点排行