Re: Stored Procedure Parameters

Posted in 2000

Jonathan Leffler — Tue, 29 Feb 2000 05:28:27 GMT — source: Informix-list mailing list archive (1991-1998)

CREATE PROCEDURE varlist(i1 integer, i2 integer default null, i3 integer default null, ..., imbored integer default null) ... END PROCEDURE; Richard Auslander wrote: > Question - Has anyone come up with a "trick" of some sort (besides using > a separate table) to pass a VARIABLE-length list of input parameters > (say, integers) to a stored procedure? > > IDS 7.x on Solaris > -- > Richard C. Auslander > Database Manager > > AirFlash, Inc. > 1733 Woodside Rd., Suite #110 > Redwood City, CA 94061 > (650) 556-7928 > > www.airflash.com -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.95 -- see http://www.perl.com/CPAN #include <disclaimer.h>