>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