SQL & PL/SQL

Hi,

I am fetching initial set of values into Oracle Table of Records Type and want to use list of values in the Select statement.

For example, try something like the following:

TYPE t_record IS RECORD (
ID TABLEA.ID%type,
NO TABLEA.NO%type,

);
v_record t_record;
TYPE t_table IS TABLE OF v_record%TYPE;
v_table t_table;

-- Code to populate the values in v_table here.

SELEC ID,NO, BULK COLLECT INTO <some other table variabes here> FROM TABLEA
WHERE ID IN v_table(i).ID;

I want to know how to use the values from Oracle Table Type in the Select Statement.