Re: Which is faster Ado or Oracle classes

ADO does in fact support in/out parameters using the command object. Stored procedures/functions and packages can all be called.

DSW "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:918oqu$3bj75$2_at_ID-62141.news.dfncis.de...
> 1) Yes
> 2) The problem here is that ODBC can't handle any OUT parameters to the
> procedure (so you're not getting anything back in your program) and OO4O
> does.
> In a particular project I have been involved with this was a real problem,
> as any status code didn't return to the VB program, the VB program just
> proceeded regardless of any sp outcome.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <fuckingstupid_at_my-deja.com> wrote in message
> news:916bhg$9rg$1_at_nnrp1.deja.com...
> > Thanks for your reply I found it informative. I'm using the oracle
> > classes like ODatabase, ODynaset and the like if thats what you mean by
> > Oracle Ole for Objects. Is that right?
> >
> > I took this part of my project over from another programmer who wrote
> > it all in ADO. He was able to call stored procedures by executing a sql
> > command with Begin; call procname; end; . So I must be missing
> > something when you say odbc doesn't deal with stored procedures. Could
> > you expand on that as well ?
> >
> >
> >
> > In article <9169dh$33spg$6_at_ID-62141.news.dfncis.de>,
> > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> > > If you mean Oracle Ole for Objects:
> > > this is a native driver, which directly interfaces through sqlnet, and
> > > supports many features not supported by ODBC (communication with
 stored
> > > procedures for instance). Also OO4O is relatively stable, while
 there are
> > > no two different ODBC drivers behaving exactly the same. Your app is
> > > definitely going to be more reliable as your are not dependent from
 all kind
> > > of ODBC drivers people might already have on their system.
> > >
> > > Hth,
> > > Sybrand Bakker, Oracle DBA
> > >
> > > <fuckingstupid_at_my-deja.com> wrote in message
> > > news:9160o2$5g$1_at_nnrp1.deja.com...
> > > > I was using ADO but was playing around with the oracle classes
> > > > (oconnect etc etc) , I'm wondering which is faster.
> > > >
> > > > I'm thinking the classes are because ado is using ODBC and has to go
> > > > thru all that. I'm not sure how oracle is doing it , probably rpcs
 in
> > > > their lib.
> > > >
> > > > I might have to explain to my boss why I changed from ado to oracle
> > > > classes.
> > > >
> > > >
> > > > thanks
> > > >
> > > >
> > > > Sent via Deja.com
> > > > http://www.deja.com/
> > >
> > >
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>
Received on Fri Dec 15 2000 - 20:11:21 CET