Subject Re: [firebird-support] stored procedure with list of values as input parameter
Author Ann Harrison
On Tue, Jan 17, 2012 at 11:44 AM, Net Newbie <netfirebird@...> wrote:
> how to create a stored procedure having a list of values as input parameter?

Its not simple, but it can be done using a string parameter (e.g. "1,
2, 3, 4") and
creating a SQL string that you feed to EXECUTE STATEMENT.

> I need to retrieve result for query looking like
> select field1, field2 from table1 where field3 in (1, 2, 3, 4);
Good luck,