Create a stored type which is visible to SQL and PL/SQL.
SQL> CREATE OR REPLACE TYPE NameList AS
2 VARRAY(20) OF VARCHAR2(30);
3 /
Type created.
SQL>
SQL> DECLARE
2 -- This type is local to this block.
3 TYPE DateList IS VARRAY(10) OF DATE;
4
5 -- We can create variables of both DateList and NameList here.
6 v_Dates DateList;
7 v_Names NameList;
8 BEGIN
9 NULL;
10 END;
11 /
PL/SQL procedure successfully completed.
SQL>
SQL>