db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Peter Yuill" <pyu...@objectix.com.au>
Subject Function or Procedure output within IN expression
Date Sat, 17 Nov 2007 02:17:10 GMT
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

Mime
View raw message