Re: Oracle API for C/C++ ?

> The Oracle precompiler actually converts Pro*C calls into OCI
> calls.

This statement is not quite true. OCI is based upon UPI. Pro*C is based upon sqllib which based upon UPI. Pro*C provides client side cursor caching, OCI does not.

> If that last time you looked at OCI was Oracle 7 or before,
> look at it in Oracle 8, they have opened it up quite a bit
> (hundreds of intrinsics rather than 40 some).
OCI8 became more like ODBC 3.x. Take a closer look at the OCI8 #defines and the OCI8 ideology at large: handles, opaque structures, etc. However, OCI8 provides more flexibility for Oracle Corp to change the implementation -- the price to be paid by the users.

I have a C++ stream based API with SQL. The API is made in the format of C++ Template wrapper around OCI7 and the same type API as a wrapper around OCI8:

        http://home.sprynet.com/~skuchin/otl_1pg.htm

Sergei

>
> In article <3808b024.432646_at_news.demon.nl>, postbus_at_sybrandb.demon.nl
> (Sybrand Bakker) wrote:
>
> > Yes, OCI, the Oracle Call Interface. This is a low level interface
> > compared to Pro*C, which is essentially a HLI (Host Language
> > Interface).
> >
> > Best regards,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > On Sun, 17 Oct 1999 01:14:07 +0800, "Chow Hoi Ka, Eric"
> > <eric138_at_yahoo.com> wrote:
> >
> > >Hello,
> > >
> > >Except Pro *C, is there any other API for C in Sun Solaris to access
> > >Oracle daatabase ???
> > >
> > >Best regards,
> > >Eric
> > >
> > >--
> > > _ _
> > > / ) |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ( \
> > > / / | | \ \
> > > _( /_ | _ Chow Hoi Ka, Eric _ | _) )_
> > >(((\ \> |/ ) ( \| </ /)))
> > >(\\\\ \_/ / \ \_/ ////)
> > > \ / E-Mail : eric138_at_yahoo.com \ /
> > > \ _/ \_ /
> > > / / |____________________________________________| \ \
> > > / / \ \
> > >
> > >
>
> --
> Shawn Lavin
> As always, my opinions are my own
Received on Mon Oct 18 1999 - 19:49:19 CDT