On Thursday, February 16, 2012, 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 ; ^

I don't know what the do something is but it could be as simple as using
the IN clause.
Alan

>
> Thanks in advance.
> Sergio (sorry my english)
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

--
regards
Alan McDonald


[Non-text portions of this message have been removed]