Lists and queries

Hi All!

I have a trouble with PL/SQL. I have a table like this:

TYPE Id_List IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; EmptyId_List Id_List;

In a HTML form I have a multiselect combobox named Elements. The Submit button calls a PL/SQL procedure defined as follows:

procedure Check(Elements Id_List DEFAULT EmptyId_List)

I have to do a SELECT with a WHERE clause in which I must utilize all the values that are in Elements parameter. Something like this:

SELECT *
FROM MyTable
WHERE Code = (Any of the value in the Elements list);

How can I realized this type of query? Anyone can help me? Thanks to all in advance.

--
Marco Minerva, vbcorner_at_libero.it
http://www.marcominerva.com/vbcorner