stored procedure how to retrive more one row ?

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.