Retrieving a result set with a TQuery

Has anyone any tips on using a TQuery to access a dataset from a
StoredProc in Oracle.  Chapter 22 of the Developer's Guide makes it look
easy but I have tried many variations on the examples to no avail.  I
have also tried to retrieve a result set with a TStoredProc but again I
have not quite been able to make it work. I want to move the processing
of the SELECT statement onto the server so I would like to find a way to
make this work.

Thanks in advance,
Bill McCarthy