Hi,

Is there a way to pass in a parameter for a WHERE IN caluse to a
stored proc?

something like this but not this

create procedure testproc
(listOfValues ?????datatype????)
returns (id integer)
as
begin
for select id from mytable where blah IN (:listOfValues)
do
suspend;
end

any idea how this kind of thing could be done?

Thanks

Giulio