Re: ESQL/C and EXECUTE PROCEDURE
Posted in 1998
That depends on whether your output will return more than one row. If only one row is being returned, then you shouldn't need to declare a cursor. You should just be able to do an EXECUTE p_exe INTO desc USING $var, as I stated. I should have cleared that up. Sorry. - Thomas J. Girsch Database Systems Manager Arch Communications Group, Inc. Jonathan Leffler wrote in message <68r9au$6mi@cssun.mathcs.emory.edu>... >Sorry to rain on the parade, but... > >The question asked about 'input and output parameters'. > >Thomas' answer is absolutely correct for input parameters; it does not >take into account the output parameters. > >AFAIK, if there are output parameters (return values would be a more >precise term; Informix does not have output parameters in the way that >Oracle does), then you have to use a cursor