How to declare a array in procedure
PROCEDURE INORUPSHIFTPATTERN_1
(
pSHIFTPATTERNID IN VARCHAR2,
pSHIFTPATTERNNAME IN VARCHAR2,
pSTARTDAYOFTHEWEEK IN NUMBER,
pNOOFPATTERNDAYS IN NUMBER,
pISACTIVE IN VARCHAR2,
pCREATEDBY IN VARCHAR2,
pSHIFTID IN ARRATYPE,
pPATTERNDAY IN ARRATYPE,
CUR_OUT OUT SYS_REFCURSOR
)
this is my procedure how can I declare array type here, pSHIFTID and pPATTERNDAY are array types
TYPE ARRAYTYPE IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
where I can write the above type in procedure and it is showing an error ARRAYTYPE must be declared please help