Re: procedure in esql

>From: syadat@mercury.eng.wayne.edu (Yadati Sainath) >Subject: procedure in esql >Date: 12 Jan 1995 22:33:43 GMT >X-Informix-List-Id: <news.10735> > >I am trying to execute a stored procedure from an esql/c routine. The >procedure will return more than one row at a time. I am finding a problem >to catch all the rows returned by the procedure. > >Please let me know the best solution for this. The answer is to DECLARE a cursor for the EXECUTE PROCEDURE statement. If you PREPARE and DESCRIBE the EXECUTE PROCEDURE statement, you can find out whether the procedure returns any values (look at sqlda_ptr->sqld for a value greater than 0); if so, then you need to DECLARE a cursor for it, but otherwise, you should simply EXECUTE it. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>