I am trying to connect to oracle database using C code. Is it possible to use OCCI in the code? If yes please help me with some examples, please note it has to be C code.
If not what are the other options to connect to database using C.
OCCI is short for 'Oracle C++ Call Interface' and is targeted to C++ applications. If your application is going to be purely in C, then you should use OCI (Oracle Call Interface) instead as that is Oracle's call interface for applications written in C.
See the Programmer's guide for help and examples.