Oracle Ref Cursor and ADO do not play well together!!

I am wondering if anyone has been able to get an ADO recordset from an oracle stored function as a return value?

I have literally tried cutting and pasting examples from the OraOLEDB.oracle documentation! It does not work, I am starting to get a little annoyed. This should not be a difficult task.

I have been searching newsgroups for 2 days and have found no sample code that works for me. I am using the latest MDAC, and all the stored functions work fine if I just call them from a SqlPlus window, etc.

When I try calling from ASP via ADO using the OraOLEDB.Oracle driver, I get an error saying there was an exception on the execute statement and then the program bombs.

Subsequent attemts to reload the page all result in an error saying create object of null caused an exception... even if comment out the execute line, this continues to happen when trying to create any ADODB object.

I found one article on MSDN saying this can happen if you store result sets in session variables, but I am NOT using session variables at all. I hate session variables.

My Oracle database is running on Unix and the web server is on Win2k advanced server SP2 (IIS 5). I have already tried updating the MDAC to the latest version, and it makes no difference. I tried using the Microsoft OLEDB driver... that does not work. I have tried everything I can think of.

If anyone has had this sort of thing happen, and you found a fix, please let me know. Thanks.

--Eric Received on Tue Oct 30 2001 - 16:09:18 CST