>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...
I think your approach is better suited to adding a VFP remote view of the Oracle table. You could even parameterize the view to retrieve only the data you need from the table.
Mark McCasland
Midlothian, TX USA