If you have the ODBC driver configured correctly, you can use SQLCONNECT to connect to the datasource, then SQLEXEC(nConnection,"stored proc",Mytable) to return record to the cursor mytable. Look in the client/server parts of the VFP documentation. What is there for SQL Server should pretty much apply to Oracle as well.


>I have an oracle package that executes and narrows my data down to several records and those need to be displayed in a fox app. How can I make the call in Foxpro to execute the stored proc in the Oracle package and then return the results.
>My package creates a variable for each column in the results of data type PL/SQL-Table and populates each one with the appropriate data. It should then return the PL/SQL-Tables. My problem is that from the reading I have done the ODBC driver will return the data as an RDO record set and I can't find anything on how to make that work with Fox. I also need help with the syntax from fox to call the oracle package.