SELECT CAST(MULTISET(SELECT FRUIT_NAME FROM FRUITS) AS TEST_PKG.TEST_VCHAR_NT) FROM DUAL

CREATE OR REPLACE PACKAGE TEST_PKG AS
  TYPE TEST_VCHAR_AAT IS TABLE OF VARCHAR2(100) INDEX BY PLS_INTEGER;
  --TYPE TEST_VCHAR_NT IS TABLE OF VARCHAR2(100);
  TYPE TEST_VCHAR_NT IS TABLE OF FRUITS.FRUIT_NAME%TYPE; 

CREATE OR REPLACE PACKAGE TEST_PKG AS
  TYPE TEST_VCHAR_AAT IS TABLE OF VARCHAR2(100) INDEX BY PLS_INTEGER;
  TYPE TEST_VCHAR_NT IS TABLE OF VARCHAR2(100);
END;

DECLARE
  AA TEST_PKG.TEST_VCHAR_AAT;  
  NT TEST_PKG.TEST_VCHAR_NT:= TEST_PKG.TEST_VCHAR_NT();  
BEGIN
  AA(0):= '1'; AA(1):= '2'; AA(2):= '3';  
  NT:= CAST(AA AS TEST_PKG.TEST_VCHAR_NT);

SELECT CAST(AA AS TEST_PKG.TEST_VCHAR_NT) INTO NT FROM DUAL;

SELECT COLUMN_VALUE BULK COLLECT INTO NT FROM TABLE(AA);