Error: PLS-00103: Encountered the symbol "CREATE"
If you create package and encountered above error, please add / as below show.
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;