Mega Code Archive

 

Categories / Oracle PLSQL / PL SQL

 

Reference Type in another block as well

SQL> SQL> CREATE OR REPLACE TYPE NameList AS   2    VARRAY(20) OF VARCHAR2(30);   3  / Type created. SQL> SQL> SQL> SQL> DECLARE   2    v_Names2 NameList;   3  BEGIN   4    NULL;   5  END;   6  / PL/SQL procedure successfully completed. SQL> SQL>