On Thursday, February 16, 2012, sergiogarciaruso <[email protected]> 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]
