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