nitingcs

 Profile Answers by nitingcs 

• Mar 18th, 2006

 

If you mean by Oracle Call Interface (OCI), it is a set of low-level APIs used to interact with Oracle databases. It allows one to use operations like logon, execute, parss etc. using a C or C++ program

suresh

• Apr 6th, 2006

 

Oracle Call level Interface

ramoojobs

 Profile Answers by ramoojobs 

• Apr 21st, 2006

 

Oracle offers a proprietary call interface for C and C++ programmers that allows manipulation of data in an Oracle database. Version 9.n of the Oracle Call Interface (OCI) can connect and process SQL statements in the native Oracle environment without needing an external driver or driver manager. To use the Oracle OCI 9i stage, you need only to install the Oracle Version 9.n client, which uses SQL*Net to access the Oracle server.

Oracle OCI 9i works with both Oracle Version 7.0 and 8.0 servers, provided you install the appropriate Oracle 9i software.

With Oracle OCI 9i, you can:

? Generate your SQL statement. (Fully generated SQL query/Column-generated SQL query)

? Use a file name to contain your SQL statement. (User-defined SQL file)

? Clear a table before loading using a TRUNCATE statement. (Clear table)

? Choose how often to commit rows to the database. (Transaction size)

? Input multiple rows of data in one call to the database. (Array size)

? Read multiple rows of data in one call from the database. (Array size)

? Specify transaction isolation levels for concurrency control and transaction performance tuning. (Transaction Isolation)

? Specify criteria that data must meet before being selected. (WHERE clause)

? Specify criteria to sort, summarize, and aggregate data. (Other clauses)

? Specify the behavior of parameter marks in SQL statements.