PL/SQL function in a SELECT statement

I need to do a SELECT statement like :

  SELECT column1 FROM table1 WHERE column2 in my_function;

( where my_function is a PL/SQL function. )

My_function must return a list of items. What type must i use for the result of "my_function" ?
(for example : column2 is a varchar2)

best regards,

   bruno Received on Wed Sep 23 1998 - 09:52:30 CDT