Advantages of OCI (versus Pro*C etc)
More fine-grained control over all aspects of the application design and execution
Use of familiar 3GL programming techniques and application development tools such as browsers and debuggers
Dynamic
- Full support for dynamic SQL
- Dynamic bind and define using callbacks
- Describe functionality to expose layers of server metadata
Asynchronous event notification for registered client applications
Enhanced array data manipulation language (DML) capability for array INSERTs, UPDATEs, and DELETEs
Thread safety so you do not have to use mutual exclusive locks (mutex) on OCI handles