Re: C Programming API for Oracle ?

In article <aak2.836342472_at_Ra.MsState.Edu>, aak2_at_Ra.MsState.Edu (Atif Ahmad Khan) writes:
|> surman_at_oracle.com (Scott Urman) writes:
|>
|> >You have two options - Pro*C and OCI. Pro*C is a precompiler, which allows
|> >you to embedd SQL calls directly in C code. The precompiler then comments
|> >these out, and replaces them with calls to the Oracle libraries. This results
|> >in compilable code. The second option, OCI (Oracle Call Interface) is a
|> >C API which you can use directly from C, with no precompiling. Both
|> >interfaces communicate with Oracle by sending SQL statements and/or PL/SQL
|> >blocks to the server to be executed. I would talk with your sales rep for
|> >more information and/or demos.
|>
|>
|> I haven't made contact with an Oracle sales rep yet. I have to find one
|> first :) For now I am planning on ordering "The programmer's guide to
|> Oracle call interfaces" and downloading the evaluation version for
|> Solaris x86. My only other question is, does the OCI stuff come with
|> Oracle Workgroup Server package or does one have to purchase it seperately ?

Depends on your platform (at least it used to). On Unix and VMS, OCI would come with the RDBMS by default. This is not true for desktop systems. I *think* that it comes with the Programmer 2000 suite, which includes both OCI and Pro*C. Or Programmer 2000 might just be the liscensing, while the software actually comes with the server.

|>
|> Thanks.
|>
|> Atif Khan
|> aak2_at_ra.msstate.edu
 

-- 
------------------------------------------------------------------------
Scott Urman            Oracle Corporation           surman_at_us.oracle.com
------------------------------------------------------------------------
Author of _Oracle PL/SQL Programming_ ISBN 0-07-882176-2
Published by Oracle Press - http://www.osborne.com/oracle/index.htm
------------------------------------------------------------------------
"The opinions expressed here are my own, and are not necessarily that of
 Oracle Corporation"
------------------------------------------------------------------------