APEX

Hi,

What is the definition of APEX_APPLICATION_GLOBAL.VC_ARR2 type ? Is this "TABLE OF VARCHAR2(32767) ?
I am asking because I want to query in a process using something like :

declare
v_arr APEX_APPLICATION_GLOBAL.VC_ARR2;
v_count number(10);
begin
v_arr := APEX_UTIL.STRING_TO_TABLE( :MY_SHUFFLE_ITEM ) ;
select count(distinct column_value) into v_count from table(v_arr) ;
end;

The "select ..." statement does not work :
ORA-06550: PLS-00382: expression is of wrong type
ORA-06550: PL/SQL: ORA-22905: cannot access rows from a non-nested table item
ORA-06550: PL/SQL: SQL Statement ignored
If I create a type : create type my_type as table of varchar2(32767) , and the use this type for v_arr ,the select statement works, but not the assignment v_arr := APEX_UTIL.STRING_TO_TABLE( :MY_SHUFFLE_ITEM ) :
ORA-06550: PLS-00382: expression is of wrong type
ORA-06550: PL/SQL: Statement ignored

Any help appreciated.