Re: EXECUTE PROCEDURE

Posted in 1994

Jonathan Leffler — 6 Jun 1994 12:43:18 -0400 — source: Informix-list mailing list archive (1991-1998)

>From: kudrass@dvs1.informatik.th-darmstadt.de (Thomas Kudrass) >Subject: EXECUTE PROCEDURE >Date: 6 Jun 1994 09:16:15 GMT >X-Informix-List-Id: <news.7056> > >We have a problem when executing a stored procedure from ESQL/C: >Are there any possibilities to call a SP with a variable argument avoiding to >specify a constant value in the argument list of the procedure ? Either write: EXEC SQL EXECUTE PROCEDURE whatnot(:variable1, :variable2, :variable3); Or: Prepare the statment with question marks in place of the arguments, and then execute the EXECUTE PROCEDURE statement with a USING clause. If the procedure returns values, you'll declare a cursor for it. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>