Re: stored procedure how to retrive more one row ?

>From: leone@galactica.it (Angelo PAGOTTO) >Date: Mon, 05 Feb 1996 19:14:54 GMT >X-Informix-List-Id: <news.20926> > >Hi my name is Angelo > >With a little help of other user I have founded how to create a stored >procedure ( by dbaccess ) but now I have a problem: >If I make a select that return more rows I recieve a error message. >Is there anyone that sends me an example of stored procedure that >return more than one records? > >for example I want to create a procedure that retrive orders >between two date. > >Thanks for your answer. Angelo - It sounds like you are attempting to do something like: EXECUTE PROCEDURE proc (d1, d2)INTO :column-list... which, like a SELECT...INTO... requires that only a singlerow be retrieved. If you have a possibility that more than one row is returned, you must use a CURSOR, and fetch each row in a loop until SQLNOTFOUND. Paul Kapp ----> PLKapp@aol.com -OR- plk@interactive.visa.com