Migrating from Informix to Oracle.

[Tinku]

Hi

We are trying to migrate a part of our application(on Solaris) from
Informix to Oracle. Most of the code written is in Informix ESQL/C.
Now I believe the Oracle equivalent of ESQL/C is Pro*C.
Can Someone please help me with some pointers as to how we go about
doing this migartion of code.

regards
Ankur

[Pete's]

anbh...@cisco.com (Tinku) wrote in message news:<c47f56ca.0311...@posting.google.com>...

Pro*C is Oracle's Pre-Compiler. Once you convert/rewrite the code,
you will need to use the Pre-compiler first, then compile the
resultant file with your C/C++ compiler and then link it. Oracle
ships examples in $ORACLE_HOME/precomp/demo/proc. Check out their
make files.

HTH,
Pete's

The opinions I may have stated here are mine and not that of my
employer.

[Edward Lloyd Hillman]

In article <c47f56ca.0311...@posting.google.com>,

I went through this some years ago. (We went from Informix 4 & 5 on
SunOS and Solaris to Oracle 7.1 on AIX.) I don't know how applicable
this is today, but here are some of the things we had to do.

* Get rid of all of the "EXEC SQL FREE <cursor_name>" statements.
* Where we had CURSOR WITH HOLD loops having COMMITs inside the loop,
we either got rid of the COMMITs, or (if that wasn't practical) used
a regular cursor to load the data into either a linked-list or an
array of structures and then processed those in an other loop that
contained the COMMITs.
* I also recall that the version of Pro*C we were using had a
"feature" wherein an "EXEC SQL INCLUDE sqlca;' statement had to be
followed by a blank line; otherwise Pro*C would fail to process it
properly.

I know there were others, but I don't recall what they were.

HTH.

--
Ed. H.
Signature?!? I don't need no stinking signature!!