Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO recordsets & Oracle
Message
From
12/12/2001 10:09:27
 
 
To
12/12/2001 09:21:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00593217
Message ID:
00593254
Views:
23
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform