Returning rows from a stored procedure - how?

We are using Oracle Workgroup Server on an NT box, and developing a front end application in VB v4 16-bit (no Remote Data Objects (RDO) available).

I would like to store all SQL used by the application in PL/SQL stored procedures. This works fine for UPDATES, DELETES and INSERTS.

However I cannot find ANY documentation telling me how to return a result set from a SELECT statement back to the front end application. I can only find comments that it is possible.

I would be grateful if someone could supply me with an example of a stored procedure that returns rows to my front end app.

TIA

-- 
Andy Noble