Oracle oci/occi

最新推荐文章于 2025-05-06 14:42:45 发布

mangix_hust

最新推荐文章于 2025-05-06 14:42:45 发布

阅读量1k

点赞数

文章标签： oracle interface database performance scalability python

本文介绍了Oracle Call Interface (OCI) 和 Oracle C++ Call Interface (OCCI) 的特性及使用方式。OCI提供了强大的接口来执行Oracle数据库中的SQL语句，而OCCI则为C++开发者提供了一个高性能且易于使用的面向对象接口。文章还展示了如何使用OCCI创建环境、连接数据库、执行SQL插入语句并终止连接。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

http://download-west.oracle.com/docs/cd/B12037_01/nav/portal_5.htm

*****************************************************

http://www.oracle.com/technology/tech/oci/index.html

Oracle Call Interface
Reliable - the Oracle Database executes SQL Statements with OCI.

When applications developers look for the most powerful and complete interface to the Oracle Database, they turn to Oracle Call Interface (OCI). Newest Oracle Database capabilities, performance, scalability, and security features appear first in the OCI API.

Languages, APIs, and applications that depend upon OCI:

Java applications using the OCI-based JDBC driver
PHP applications using the Oracle PHP adapter
Ruby/Rails applications using Oracle Ruby adapter
Python applications using Oracle Python adapter
Perl applications using Oracle Perl adapter
PL/SQL applications executing SQL
C++ applications using OCCI
C applications using the ODBC driver
VB applications using the OLEDB driver
.NET applications using the ODP.NET driver
Pro*C applications
Distributed SQL

*****************************************************

http://www.oracle.com/technology/tech/oci/occi/occibasic.html

Oracle C++ Call Interface (OCCI)

Are you interested in creating applications with the speed of OCI, but want seamless integration with C++? The Oracle C++ Call Interface offers C++ developers a high performance connection to the Oracle database in a well-designed Object Oriented interface.

A Simple Useful OCCI Program

//create environment and connection

Environment* env = Environment::createEnvironment();

Connection* conn = env->createConnection( "scott", "tiger" );

cout << "Environment and Connection created" << endl;

//execute a SQL statement

Statement* stmt = conn->createStatement();

stmt->setSQL("INSERT into FRUITS (fruit, amt) VALUES ('apple', 10)");

stmt->executeUpdate();

conn->terminateStatement(stmt);

//terminate environment and connection

env->terminateConnection(conn);

Environment::terminateEnvironment(env);

cout << "Environment and Connection terminated" << endl;