I need to add an Oracle database to a C program. It's great that Oracle
makes 10g available for free. But I've spent hours looking for
information and tutorials for a C API and it's unproportionally difficult
compared to similar products (e.g. solaris) for find anything.

In fact, I finally identified OCI and some simple demo programs - like
cdemo81.c (from
http://download-uk.oracle.com/docs/c...em.htm#i459676)
.... but it's in the 8.1 release. In my 10g release, I only find demos for
special facilities. There is no access to the files from that web site.
Also not on the Oracle web site. Also not on the net.

So, it looks like there was reasonable documentation, and it has been
removed from the distribution.

What does Oracle have against C?

On May 24, 1:53 pm, "Charles T. Smith" <cts.priv... (AT) yahoo (DOT) com> wrote:
Oracle doesn't have anything against C.
Originally there was (and probably still is) pro*C and OCI.
Pro*C is a so-called Host Language Interface, which takes away from
you the chores of setting up a cursor.
If you compare OCI to Pro*C, OCI is only the raw materials, where
Pro*C provides building blocks.
There are Pro*C demos in 9i (look for files ending in .pcc in proc
directories), I don't think Oracle has obsoleted Pro*C.
There also is a C++ interface, called OCCI, which is discussed at
http://www.oracle.com/technology/sam...cci/index.html

I admit this is hard to find, but it is there!

Hth
--
Sybrand Bakker
Senior Oracle DBA