Hello,
I am trying to modify a VFP application than runs against an MS SQL server, so that it can run against an Oracle 8i database.

I have not been able to figure out what to do with SQL Server stored procedures that return a result set. Oracle suggests that I define a cursor in a package and a procedure that returns this cursor. But how do I create a cursor variable in VFP and pass it to Oracle?


That is, I need to do:
sqlexec(conn,"exec sp_something(curvar)")
where sp_something expects a (oracle) cursor variable.

Any help or pointers will be appreciated

TIA