Which one: OCI or the Oracle Compiler?

From: Ramon F Herrera <ramon_at_conexus.net>
Date: 28 Jan 2007 13:35:40 -0800
Message-ID: <1170020140.120994.223940@l53g2000cwa.googlegroups.com>

I have a lot invested in OCI programs, written under Linux and Solaris. Since I have seen some annoying bugs, I am considering switching to the Oracle Compiler. I realize that Oracle's writing on the wall is to switch to Java, and I am as fan of Java as anyone. Having said that Java will never be as fast as a compiled application, that's why I am limiting my choices to OCI and Oracle Compiler.

I use Java for other things, not to interface with Oracle in an application that demands high performance.

One of the bugs I have found are is big selects:

SELECT A,B,C,...,Z FROM table

My temporary solution is this:

SELECT * FROM table

My feeling is that Oracle is not investing too many resources to improving OCI.

Should I expect more reliablility/fewer bugs if I move to the Oracle Compiler?

-Ramon Received on Sun Jan 28 2007 - 15:35:40 CST