OCI support in future Oracle Releases

>HALEH HARIRIAN writes:
>We are starting a new project in Oracle, probably using Windows NT as a
>client. We would like to use OCI because it will fit better with our
>design plans, and because we feel more comfortable with API database
>interface. But we heard that most of the Oracle community uses embedded
>Pro*C, and that OCI may not even be supported in Oracle 8. How true is
>this? Also, approximately what percentage of Oracle applications are
>developed with OCI? Is it true that Pro*C does not work very well with C++?

Oracle is strongly committed to both OCI and Pro*C and we continue to enhance both interfaces with every release. Both interfaces are extremely popular with our power users (ISVs, VARs, etc.) picking OCI for flexibility, performance, and explicit control while others picking precompilers for fast learning, standards compliance, and embedded SQL approach. C++ is supported in OCI and in Pro*C starting with 2.0.4 release, which is getting into beta right now. Pick the one that makes sense for you. OCI is the stick-shift while precompiler is your automatic drive.

With Oracle7 release, we fine tuned both OCI and precompilers for client/server environments to reduce the network traffic. New calls were added in OCI to provide deferred calls, piece-wise fetched of LONG columns, etc. Pro*C 2.0, released with 7.1 release of Oracle7, provides support for C preprocessor (#define, #include, etc.), C structs, etc.

With 7.1 release of Oracle7, we have introduced a new product, SQL*Module. SQL*Module offers a standards-based SQL Module Language interface to Oracle7. Unlike the embedded SQL interface style, the SQL Module Language style isolates SQL statements in separate files, called modules, and makes them available to the applications via simple host-language procedure calls. SQL*Module supports Ada, C, and C++.

Hope it helps.

If you have more questions, please feel free to contact the following Product Managers Bhushan Fotedar (BFOTEDAR.US.ORACLE.COM) and/or Peter Vasterd (pvasterd_at_oracle.com).

-Debu
dchatter_at_us.oracle.com Received on Tue Aug 30 1994 - 22:44:54 CEST