Selecting from a list variable in PL/SQL
Why doesn't the initially remarked select work please?
DECLARE
TYPE table_list_type IS TABLE OF VARCHAR2(40);
v_table_names table_list_type;
v_table_name VARCHAR2(40);
v_pre_del_count NUMBER(8);
v_post_del_count NUMBER(8);
BEGIN
v_table_names := table_list_type(
'ACCOUNT_PERFORMANCE_DAILY',
'CLIENT_PERFORMANCE_DAILY',
'CORE_CASH_PERF_DAILY',
'CORE_STOCK_PERF_DAILY',
'SECTOR_PERFORMANCE_DAILY',
'CORE_STOCK_PERF_DGROUPS',
'CORE_CASH_PERF_DGROUPS',
'CLIENT_PERFORMANCE_DGROUPS',
'ACCOUNT_PERFORMANCE_DGROUPS',
'SECTOR_PERFORMANCE_DGROUPS');
FOR i IN v_table_names.FIRST..v_table_names.LAST
LOOP
DBMS_OUTPUT.PUT_LINE( 'v_table_names(i) '||v_table_names(i) );