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

Thanks, though I already saw this link in many of the older posts in this group and I already tried all the methods listed there.

Very frustrating...

I finally have resigned myself to the fact the ADO just doesn't work well with oracle.. it seems as if this might be yet another microsoft invention designed to break the competion's product... so I re-coded my application's functions to use OO4O (Oracle Objects for OLE). Now everything works smoothly. I have not had any further trouble and OO4O seems to have all the same functionality that I was looking for from ADO. I would advise anyone interfacing with Oracle from a windows platform to use OO4O and don't waste your time playing with ADO.

Enjoy!

--Eric

Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:<9rnkbl0jh1_at_drn.newsguy.com>...
> 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
Received on Wed Oct 31 2001 - 17:17:37 CST