Review Building Best OCI-based Drivers (White paper)
471042Jul 16 2008 — edited Jul 22 2008I had the opportunity to have an early look at this Luxi's paper a few so for the benefit of others I will give you a quick review of it.
The paper goes over what need to be done to use OCI effectively especially in a web environment.
The step by step approach taken in this document is very readable and the well explained code snippets makes it a very good reference to compare your code with the 'Proper' way to do it.
The novice OCI-Head will find the initial sections of great benefit as it takes allot of mystery out of OCI programming.
For more advance OCI-Heads the document is full of good examples of how to manage connections, sessions and pooling with and examination of what type of pooling is needed in a given situation.
One highlight for me was the section on DATABASE EVENTS which is covered very effectively with some practical examples.
So to sum up it is a must read for the master OCI or the novice with some great pointer on how to use what is already in OCI and what is new in 11.