Currently tasked with migrating Informix ESQLC files to Oracle Pro*C and have a few questions. First, we use a lot of proprietary Informix functions within our embedded ESQLC code such as rstrdate(), rtoday(), and rjulmdy().
Any pointers on how to convert these in Oracle Pro*C?
Another thing I'm struggling with understanding is the Oracle date datatype. In Informix, we use type long in our embedded sql C code for any host variables dealing with dates for the Informix tables.
But in Oracle, I'm under the impression that dates aren't communicated back and forth as long, but as char? Or can we still specify host variables as type long?
Jonathan Leffler :
Googling \"Oracle OCI Date\" comes up with functions such as OCIDateTimeFromText(), OCIDateSysdate() and maybe OCIDateTimeToArray() corresponding to the ESQL/C functions you name. There is an OCIDate type that probably corresponds more closely to an ESQL/C dtime_t (it likely includes the time components) than an Informix DATE (int4 or long in ESQL/C), but it is most likely the type you should be using in your translation process.",
2009-04-22T19:52:41