I've used OO4O a lot and love it. Especially if you follow the performance
tips and use parameters (bind variables for you OCI folks). In my apps I
write a class around the cursor so I only open it once while the app is
running and just set the parameters to different values and reexecute.
Gives you nice performance.
Jim
"ericn" <ericn_at_sarek.cjb.net> wrote in message
news:a271a1ed.0110311517.63cd0504_at_posting.google.com...
> 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 - 19:49:47 CST
