VARRAY_FORLOOP1.htm
Oracle Collections Types : Varrays,Nested tables,Associative arrays

The collections 12c, VARRAY is synonymous of  ARRAY , and limit should be defined before  compilation.

Below is an example of using VARRAY in procedure.

FYI: The TABLE function converts a static array to a dynamic list.
SCRIPT:

SET SERVEROUTPUT ON;
CREATE OR REPLACE PROCEDURE m5_varray1 AS
TYPE m5_array IS VARRAY(5) OF VARCHAR2(20);
lov_varray m5_array := m5_array('JAN','FEB','MAR','APR');
BEGIN
FOR i IN 1..lov_varray.COUNT LOOP
IF i<= lov_varray.COUNT THEN
dbms_output.put_line(
'MONTH('||i||') ['||lov_varray(i)||']');
END IF;
END LOOP;
END m5_varray1;
/
CALL m5_varray1();