Function or Procedure output within IN expression

[Peter Yuill]

Hi,

I am attempting to use the output of a function or procedure in place of
the list of values or table subquery of an IN expression eg 'SELECT *
FROM TEST WHERE ID IN (TEST.MY_PROC(?))'. It works with a single value
return from a function, but this is not very useful. Is there any way to
return a list of values from a function or to get a procedure result set
treated as a table subquery?

Thanks,
Peter