>I'm trying to get a recordset back from an Oracle database using ADO.
>
>I've tried to create a package function on oracle, but ADO won't have it..it only wants a procedure. As a result I have to return the cursor as a parameter..OK on the oracle side but what data type do I set the parameter to in VFP?? I've tried adArray and adUserDefined with no luck so far.
>
>Or am I barking up the wrong tree???
>
>Thanks in advance...
>
>Pablo
What's your ADO code?
If you are returning a cursor you will probably get back an ADO recordset. Something like this should work:
oRS = oCn.Execute(cSQL)
Where oCn is your opened connection object and cSQL contains the SQL statement that returns the cursor. HTH