I have a system that pulls from two datasources: a SQL 6.5 database and an ORACLE database. (I do not code or maintain either database. They are client databases.) I'm able to access a stored procedure on the SQL database and get the recordset with no problems. The problem is the ORACLE database. They want to write the stored procedure and return the recordset, but we can't get it to work. Is there a way to do it using SQLEXEC() as I do with the SQL database? All the examples I've seen creates the stored procedure from FoxPro and then accesses it. They don't want me to create the procedure from my end. I don't think the problem really is my FoxPro code. They have admitted to me that they have never done this before and aren't sure how to pass a result set.

Can anyone help for the code on BOTH ends?

TIA

Tom