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.
Thanx,
Bill Elvin