Oracle 10g and floating point numbers

[Shael Richmond]

We are testing Oracle 10g and found a major issue. Oracle will no longer return floating point numbers in VMS formats only the IEEE format. Oracle's response is to compile the code with the /float=ieee switch (Fortran or C). We are unable/unwilling to do that. We did test it and it works. We have several options but none of them good. Oracle has created a BUG to get a response from engineering.

Has anybody else come across this? I don't know how many VMS Oracle users still use embedded SQL in Fortran or C.

[Marc Van den Broeck]

Shael,

Fortran?

Is there still a Fortran pre-compiler with Oracle10? I thought the last one came with Oracle8?

We use embedded Fortran and C and we plan to move the Fortran code to C.

Rgds
Marc

[Steven Schweda]

I can't help here, but I'm curious as to why
re-compiling your code with /float=ieee is
not acceptable. I know that change is
intrinsically bad, but do you have a better
reason?

[Shael Richmond]

Yes there is still a Fortran precompiler. There are no new enhancements but it's still there!

[Shael Richmond]

We don't want to recompile because of everything it might effect. We have some modules that use embedded SQL for Oracle and Codasyl DBMS. In addition, DECForms doesn't support the /IEEE switch.

Our best options right now are:
1) Stick with Oracle 9i
2) Migrate to Oracle 10g but keep using the Oracle 9i client.

The downside is support will eventually stop.