topic Re: Oracle 10g and floating point numbers in Operating System - OpenVMS

Oracle 10g and floating point numbers

Shael Richmond — Wed, 25 Jan 2006 16:17:56 GMT

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.

Re: Oracle 10g and floating point numbers

Marc Van den Broeck — Thu, 26 Jan 2006 01:43:50 GMT

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

Re: Oracle 10g and floating point numbers

Steven Schweda — Thu, 26 Jan 2006 02:58:48 GMT

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?

Re: Oracle 10g and floating point numbers

Shael Richmond — Thu, 26 Jan 2006 10:31:55 GMT

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

Re: Oracle 10g and floating point numbers

Shael Richmond — Thu, 26 Jan 2006 14:41:35 GMT

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.