Mega Code Archive

 

Categories / Oracle PLSQL / Object Oriented Database

 

Reference user-defined data type in another block

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