Re: General Question about OCI

Jens Albrecht <Jens.Albrecht_at_informatik.uni-erlangen.de> wrote:
> Why is OCI better than embedded or dynamic SQL?
> Performance? If so, where does the improvement come from?
> The array functions?
>
> -- Jens

OCI and Pro*C do NOT share the same code-base (DLL/Shared libs etc) and i've heard that the oci libraries are more efficient then pro*c's (i didn't notice any difference). However with oci you are in complete control (when cursors are released etc).
In my experience it is easier to code dynamic (pl/)sql (ie: read from a file) using oci than with Pro*C. Both oci and pro*c support the array-interface so thats not a real issue. I started using pro*c for my c programs but (at that time) pro*c didn't support C++. In the beginning the learning curve for oci is a little steeper then pro*c, but you can easily build your own class-library for it (or you can buy a product like RogueWave's dbtools++ so you'll be database-independant).

hth

        Gert Received on Wed Apr 16 1997 - 00:00:00 CDT