Does Pro*C++ do the same stuff as OCI???

[Quoted] I've been architecting a data access approach for a large systems development project. We are executing read-only stored procedures on our Oracle server and the architecutre behind it abstracts the lower level Oracle "stuff". So basically the programmers pass in an input and output structure and loop to fetch all the rows in the result set.

So far i've been assuming that the architecture functions that will be written will use OCI to interact with Oracle. Today i found out that we have a standard around here that says we need to use Pro* C. For some reason i think OCI is probably better in this case, but i need to articulate this.

What are the main reasons for using OCI over Pro*C? I will be managing multiple persistent connections in the application, can i do that with ProC*. Are there any perfomance issues? Is there a different approach in ProC* for retrieving multple results into a cursor (from within a stored procedure) that OCI?

Any thoughs??

Thanks in advance!

-david m rosner

-------------------==== Posted via Deja News ====-----------------------

      http://www.dejanews.com/ Search, Read, Post to Usenet Received on Mon Feb 02 1998 - 00:00:00 CET