use a string with a separator of your choice for the array ?
ex: tab1#tab2#tab3#....
while position('#' in myarray) > 0 do
Currenttab = substring(...);
....
end
--- In [email protected], "sergiogarciaruso"
<sergiogarciaruso@...> wrote:
>
> Hi. I would like to parameterize a procedure with a dynamic array. Is there
> such functionality in Firebird? And if so, how is the syntax? I have FB v2.5
> SS installed. I want to do something like this:
>
> SET TERM ^ ;
> CREATE OR ALTER PROCEDURE MyProc(
> p_inputparam INTEGER,
> p_dyn_array My dynamic array ¿HOW TO DO THAT?
> )
> AS
> DECLARE i INT;
> DECLARE Total INT;
> BEGIN
> Total = SIZEOF(p_dyn_array); --Retrive the number of elements of my
> dynamic array
> i = 0;
> WHILE (i < Total) DO BEGIN
> i = i + 1;
> -- Do something
> END
> END^
> SET TERM ; ^
>
> Thanks in advance.
> Sergio (sorry my english)
>
