Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning data sets from an Oracle Stored Procedure
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00325315
Message ID:
00326297
Views:
37
>That didn't work. Stored Procedsures in Oracle don't return anything unless it is by refrence so you can't expect it to return a cursor by just passing a name as the second parameter. I have been doing a ton of reading on the subject and have found some things for VB that use ADO or the PL/SQL-table type variable (C++ charicter array) but those are a pain to deal with. I also read somthing about a refrence cursor available in the beta version of ADO 2.5. If you have any other suggestions I'm open because these are uncharted waters for me.

Uncharted for me as well. Sorry, I missed seeing that you are storing your results set into variables. How are you doing this? Declaring a cursor and using FETCH? I am curious to find out how you are getting a multi-row results set. All the examples I find only operate on one row at a time and handle multi-row functions using a FETCH in a loop.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform