I have a requirement to use stored procedure for all
calls to our Oracle server.

When I was using SQL Server 6.5 I could simply create
a stored procedure as such:

SELECT * FROM table

I would then be able to manipulate the 'sqlresult' cursor.

I would like to do the same thing in an Oracle 8 environment
but it appears that Oracle requires that I write the
results to a permanent table.

How can I create a stored proc that will simply select all
data from a table and then let VFP maninpulate the results?

I would think that this would be easy...