Re: converting from SQL Server to Oracle

Jennifer,

Yes they could use Pro*C to call the PL/SQL procedures, but I am unsure if that is what they are looking at doing since they are concerned about returning result sets from Oracle stored procedures. I assume that the program is currently written using Visual C and a Microsoft ODBC driver, since the database implementation is in SQL Server. We have a similar request to do the same to a custom VB application that was written by the company that I work for.

Microsoft has done some things to their ODBC driver for Oracle that allows it to simulate the returning of result sets via the ODBC driver. Check the Microsoft Knowledge Base articles #Q176086 and Q176936 they relate to what needs to be done in Visual Basic, but should provide a good starting point. I would assume that there are equivalent articles for Visual C/C++.

Good Luck
Shawn Ramsey

Jennifer Neff <jneff_at_connectnet.com> wrote in message news:36F97D98.8718D812_at_connectnet.com...
> We're looking at having our contractor convert their code from SQL
> Server to Oracle 7.3.3 so we're both talking to the same database. Their
> code is written using stored procedures and C++. Is the easiest way to
> convert this using Pro*C to call the PL/SQL stored procedures? Their
> biggest concern is that the stored procedures return record sets and
> they need to use something that handles cursors and record sets.
>
> Thanks in advance for any help.
>
> Jennifer
>
Received on Thu Mar 25 1999 - 14:31:42 CST