Re: ProC question

Hi Robert,

"Robert J. Rubin" wrote:
>
> Though not new to databases, I am to new Oracle. So here's a few newby
> questions:
>
> 1) For new development, is there anyone (else) using ProC/C++. (As an old
> fart, I like writing SQL).

There is of course a large number of Pro*C programmers, including me and a number of collegues of mine.

>
> 2) I'm looking at the multi-threaded features in ProC. Using these methods,
> I presume I'll need to use Oracle extentions to EXEC SQL to allow multiple
> SQLDA structures for my multiple threads.

I experienced unsolvable problems when trying to wrap fully dynamic ProC statements into C++ classes. The reason is there are no genuin statement/cursor handles in ProC, they are only visible to the preprocessor.

On the other side you can rely on the OCI API (which has changed heavily between Oracle 7 and 8). OCI is very low-level and tedious to program with.

As a very good starting point look at the sources of the perl DBD/Oracle module, which provides for an excellent object-oriented interface to dynamic SQL.

If you have succeeded and are willing to publish your solution as OSS, please let us know.

Best regards

-- 
Uwe Schneider       | Telefon +49 7251 / 82587
Karlsdorfer Str. 31 | Mail    pi_at_richard-schneider.de
DE-76646 Bruchsal   | 
Linux - OS al dente!