Fetching a resultset from an stored procedure

Hi,

My objective is to move the business logic from EOF to the database, for 
example reporting, view only data etc.
I want to return multiple rows from an Oracle Stored Procedure(resultset) 
to the Application. I am trying to use the method 
rawRowsFromStoredProcedureNamed provided in EOUtility but was at a loss to 
understand how to write the stored procedure and the declaration in the 
EOModeler. 

1.) Should I write a stored procedure(with OUT variables) or a function 
which returns this resultset (if this is possible!).
2.) What do I declare the return type of the OUT variables in the stored 
procedure.
3.) How do I declare this OUT variable(s) in the EOModeler. If this is 
Custom, will I have to write conversion methods?

I tried returning the return variables as a  Table of String, Number etc 
in the stored procedure. However it gave me an ora-6550 error at Runtime. 

Thanks in advance,

Mohit Gupta