oracle - Working with Multi-Select Drop Downs -

i have multi-select drop down list in user can select multiple options, how can pass multi-select options select query.

code

select number table(get_number(('('1','2','3','4','5')','7','8')));

where 1, 2, 3, 4 , 5 multi-select options selected multiselect dropdown box. in get_number function passing count_number, role_number , test_id. count_number represents multi-select options user select. question how can consume multi-select values user entered in get_number function, not sure if possible need define count_number array in get_number function ?

it not clear you're trying achieve. below example of function uses arrays parameter , output.

sql> create or replace type tab_number table of number;   2  /  type created  sql> create or replace function get_number (p_array tab_number)   2     return tab_number   3    4     l_result tab_number := tab_number();   5  begin   6     in 1..p_array.count loop   7        /* array */   8        l_result.extend;   9        l_result(i) := 2 * p_array(i);  10     end loop;  11     return l_result;  12  end;  13  /  function created  sql> select * table(get_number(tab_number(1,2,3,4,5)));  column_value ------------            2            4            6            8           10