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
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only