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;