Re: stored procedure having an arrays as parameter (IDS 9.40)

No, no arrays. Use a temp table or a permanent staging table to pass the array of values instead. If you use a temp table the procedure will recompile itself each time it is run (as the table didn't exist at compile time). If you use a permanent staging table that problem goes away. You can use the session_id as a key to the rows in the staging table that belong to the particular function call for a session. Art On Fri, Mar 20, 2009 at 3:43 PM, Gentian Hila <genti.tech@gmail.com> wrote: > Is it possible to have a stored procedure in IDS 9.40 that accepts an > array as parameter? > > If so how can it be declared and how can it be accessed in the body of > the stored procedure. > > > Thank you very much. > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.