| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: converting from SQL Server to Oracle
A copy of this was sent to Jennifer Neff <jneff_at_connectnet.com>
(if that email address didn't require changing)
On Wed, 24 Mar 1999 16:04:41 -0800, you wrote:
>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
they would use either Pro*C or OCI. If they are dblib/ctlib programmers, OCI might feel more comfortable to them (its a C level api) but I believe Pro*C to be more productive myself.
As for the result set stuff, you might want to see http://www.dejanews.com/[ST_rn=ps]/getdoc.xp?AN=454287647
It shows how to do it.
Also, there are 'conversion' kits freely available. These point out some of the pitfalls and workarounds with the conversions. They are a good tool to have in your toolbox (as long as you don't expect them to do 100% of the work that is...) To get them, you need an account on technet -- thats free, just goto http://technet.oracle.com/ and get an account. Once you have an account, goto http://technet.oracle.com/ -> "Find" and search for:
conversion kits
you'll see them all there.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |