OCILIB is an open source and cross platform Oracle C and C++ library that delivers fast and reliable access to Oracle databases.
The OCILIB library:
offers a rich, full featured and easy to use C API
runs on all Oracle platforms
is written in pure ISO C code with native ISO C Unicode support
provides also a C++ API written in standard C++03
encapsulates OCI (Oracle Call Interface)
is the most complete available OCI wrapper
OCILIB is used in applications and database layers written in various languages such as C, C++, Objective-C, D, Rust, Go, Swift, Haskell, Erlang, Lisp, PureBasic, Blitz BASIC, Racket and others.
OCILIB runs on any 32 bits and 64 bits platform having an ISO C compliant compiler and supported by Oracle.
The C++ API is pure ISO C++03 and compiles with any C++03 compliant compiler.
Here is the lists of validated configurations.
Windows
Unix (AIX, HP-UX, Linux)
Mac OS X
Solaris
Microsoft C compiler
GCC, MinGW
IBM XL C
Intel compilers
LabView
TCC
Various CCs
OCILIB C API shall compile with any C99 compliant compiler
Microsoft C++ compiler
G++
CLang
OCILIB C++ API shall compile with any C++03 compliant compiler
Pure ISO C API
Pure ISO C++ API
Easy API (JDBC's like)
Cross platform
Compatible with all Oracle versions >= 8i
Full Unicode support (UTF-8 and UTF-16)
Supports static / shared oracle linkage
Supports runtime loading of Oracle shared libraries
Error handling (global and thread contextual)
Small memory usage
OCILIB supports all Oracle SQL and PL/SQL datatypes :
Scalar types : CHAR, VARCHAR, VARCHAR2, NUMBER, FLOAT, ...
binary types : RAW, LONG RAW, VARRAW, ..
Larges objects : BLOB, CLOB, NCLOB, BFILE, CFILE
LONG types: LONG, VAR LONG, ...
Date, Timestamps and Intervals : DATE, TIMESTAMP, INTERVAL
PL/SQL types : Ref cursors, PL/SQL Tables
Objects (Named Types) and Objects references (REFs)
SQL Collections : VARRAYs and Nested Tables
ROWIDs and UROWIDs
Easy and complete API providing more than 600 functions
Full support for OCI relational API
Full support for OCI object API
Host variable binding
Array interface binding and batch errors handling
Oracle connection and session pools
Scrollable cursors
Direct Path loading
Oracle Advanced Queues(Oracle AQ)
Oracle XA connectivity (X/Open Distributed Transaction Processing XA interface)
Oracle TAF (Transparent Application Fail-over) and HA (High availability) support)
Oracle SQL "Returning into" DML feature
Binding array Interface
Scrollable statements
Statement cache
Startup/shutdown remote Oracle instances
Oracle Database Change notification / Continuous Query Notification
Oracle warnings support
Global transactions
Provides Hash tables support
Provides portable threads and mutexes API
Describe database objects
OCILIB documentation
Article about OCILIB on www.codeguru.com : "Faster and Friendlier Access to Oracle's OCI API"
French Tutorial on www.developpez.com : "Développer une application Oracle en C/C++ avec la librairie OCILIB"
Example of a complete minimal OCILIB application :
Example of a complete minimal OCILIB application :
D: Deimos
Go: gocilib
Swift: SwiftOracle
Erlang:prophet
Lisp: cl-oracle
Haskell: hocilib
PureBasic: RWrappers
