Oracle C++ Call Interface Programmer's Guide 10g

Peter Kitson

ISBN : -

Order a printed copy of this book from Amazon --UNAVAILABLE--

Cover Design - Oracle C++ Call Interface Programmer's Guide 10g

For your free electronic copy of this book please verify the numbers below.

(We need to do this to make sure you're a person and not a malicious script)

Sample Chapter From Oracle C++ Call Interface Programmer's Guide 10g
Copyright © Oracle Corp

Overview of OCCI

Oracle C++ Call Interface (OCCI) is an Application Programming Interface (API)
that provides C++ applications access to data in an Oracle database. OCCI enables
C++ programmers to utilize the full range of Oracle database operations, including
SQL statement processing and object manipulation.

OCCI provides for:

Ś High performance applications through the efficient use of system memory and network connectivity
Ś Scalable applications that can service an increasing number of users and requests
Ś Comprehensive support for application development by using Oracle database objects, including client-side access to Oracle database objects
Ś Simplified user authentication and password management
Ś n-tiered authentication
Ś Consistent interfaces for dynamic connection management and transaction management in two-tier client/server environments or multitiered environments
Ś Encapsulated and opaque interfaces

OCCI provides a library of standard database access and retrieval functions in the
form of a dynamic runtime library (OCCI classes) that can be linked in a C++
application at runtime. This eliminates the need to embed SQL or PL/SQL within
third-generation language (3GL) programs.

Benefits of OCCI

OCCI provides these significant advantages over other methods of accessing an
Oracle database:

Ś Leverages C++ and the Object Oriented Programming paradigm
Ś Is easy to use
Ś Is easy to learn for those familiar with JDBC
Ś Has a navigational interface to manipulate database objects of user-definedtypes as C++ class instances

Procedural and Nonprocedural Elements

Oracle C++ Call Interface (OCCI) enables you to develop scalable, multithreaded
applications on multitiered architectures that combine nonprocedural data access
power of structured query language (SQL) with the procedural capabilities of C++.
In a nonprocedural language program, the set of data to be operated on is specified,
but what operations will be performed, or how the operations are to be carried out,
is not specified. The nonprocedural nature of SQL makes it an easy language to
learn and use to perform database transactions. It is also the standard language
used to access and manipulate data in modern relational and object-relational
database systems.

In a procedural language program, the execution of most statements depends on
previous or subsequent statements and on control structures, such as loops or
conditional branches, which are not available in SQL. The procedural nature of
these languages makes them more complex than SQL, but it also makes them very
flexible and powerful.

The combination of both nonprocedural and procedural language elements in an
OCCI program provides easy access to an Oracle database in a structured
programming environment.

OCCI supports all SQL data definition, data manipulation, query, and transaction
control facilities that are available through an Oracle database server. For example,
an OCCI program can run a query against an Oracle database. The queries can
require the program to supply data to the database by using input (bind) variables,