Re: ProC vs. C++ with OCI

James Woodger wrote:

> I'd like opinions on why I might choose ProC vs. C++.
>
> My current impression is that the database is easier to access from ProC
> but you can get integrated C++ development environments (e.g. Visual
> C++) that makes editing and debugging complex code easier. Importantly,
> one must use OCI to access the Oracle DBMS from C++.
>
> Questions:
> 1. Are there other compelling diferences between ProC and C++?

ProC can be used in the C or C++ environment. ProC requires a precompiler passprior to compiling. This can be integerated into any environment via the makefile.

> 2. How solid is the OCI interface?

Quite solid. The current version is multithread safe with appropriate flags.

> 3. How easy to learn and use is OCI for routines with a lot of database
> access? (would embedded PL/SQL be a much easier route for routines with
> Heavy database access?)

OCI calls are quite cryptic -- with lots of variables that appear to be unused.The binding of variables is quite verbose. In general OCI is verbose and it
makes life hard.

I think that ProC is easier to read -- more like PL/SQL.

There are wrapper classes constructed that makes the OCI look more like ProC.

I think that ProC would be the choose if no other constraints. Generally the issue is
that the ProC is part of the Developer environment and is an added expense. The OCI
environment is free with Oracle.

Mike Krolewski

>
>
> I would really appreciate a copy of any replies at jwoodger_at_sympatico.ca
Received on Mon Jun 15 1998 - 07:17:10 CEST