Re: ODBC vs Pro*c or OCI

I have programmed using Pro*C for 4+ years. I can tell you that it will provide you with the code that will be the easiest to maintain because it's syntax matches with Oracle's syntax when using SQL*Plus. I have seen only snippets of OCI code. I'm sure it will provide the best performance, but it is very complex. Through SQL tuning and a good schema design, you should be able to meet your performance objective since it seems you will be running it on a UNIX platform.

Best of Luck!
HAP

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
All that is visible must grow beyond itself
and extend into the realm of the invisible.
         -- Dumont, the tower guardian, _TRON_


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.