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

On 30 Oct 2001 14:09:18 -0800, ericn_at_sarek.cjb.net (ericn) wrote:

>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

Could you please be *as specific as possible* and provide *more* detail than just *it doesn't work' like *specific* error messages?

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Oct 30 2001 - 16:35:53 CST