Subject Stored procs and array parameters...
Author Greg At ACD
Hi all,

I realize that in FB 1.5 there is no support for passing arrays as
parameters to stored procedures (e.g. array of integers or strings).
Is this something that is being considered for a future release? Any
alternatives to this that may work?

One possiblity would be to pass in a comma separated string to the
stored proc, and have the stored proc parse it, but I keep thinking
that having the calling application generate this and have the
stored proc parse it would take more time than its worth :( .

In one situation, my client application (VC++, SQLAPI interface)
calls a particular stored procedure once for each element in an
array of strings. Of course, each call has some overhead (create
SQL, prepare (parse) over network, execute, package results, send
back over nework, repeat), so if I could call an SP that would take
the array of strings as input, it would likely be more
efficient... :)