fetch EOs using Oracle stored procedures

Maybe I'm missing something somewhere, but I can't seem to find the answer.

To optimize things, I'd like to do a frequent fetch using Oracle stored
procedure. There are two parts to this:

1. How do I write the Oracle stored procedure in PL/SQL? What should be
returned? According to Tom Kyte, this is how it's done:

http://asktom.oracle.com/tkyte/ResultSets/index.html

I was able to create the stored procedure that returns a cursor. But I
couldn't fetch from EOF? Or should the stored procedure return something
other than a cursor?

2. How do I fetch the result set from an Oracle stored procedure into EOF?
Ideally, I'd like to fetch the results as EOs, not raw rows.

EOUtilities.rawRowsWithQualifierFormat() doesn't like the store procedure
that returns a cursor (or maybe I didn't do it correctly?). And if using
this approach, then EOUtilities.objectFromRawRow() actually turns the raw
rows into faults, resulting yet another trip to the database, which is not
desirable.

Thanks for your help!

^James