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

In article <a271a1ed.0110301409.3703c69b_at_posting.google.com>, ericn_at_sarek.cjb.net says...
>
>I am wondering if anyone has been able to get an ADO recordset from an
>oracle stored function as a return value?
>

see
http://osi.oracle.com/~tkyte/ResultSets/index.html

there are examples there.

>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

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp