Problem with Oracle 10

[IngoBfN]

Hello !

We have an application developed against Oracle 8 / 9 and it always worked fine.
Recently we have migrated our database from Oracle 9 to Oracle 10 and now there pop up error messages like ": different types on field : expected: Float, found: Integer".
There haven't been any changes to the database fields on the migration from O9 to O10, the field in question is of the Oracle datatype NUMBER(5).
Changing the datatype of this field for instance to NUMBER leads to erro messages "Query name>: different types on field : expected: Integer, found: Float".

Has anybody any ideas how to solve this ?

Thanks a lot

Ingo Heide, BfN, Germany

PS: BfN is "Federal Agency for Nature Conservation"

 

[sinys]

Do not define fields in design time.

 

[IngoBfN]

Unfortunately we didn't develop the application in question by ourselves, we had outsourced the development.

As far as I know the application was developed under Delphi5 with DAO 3.5 and the developer used the Delphi Variant type for accessing the database fields. Obviously Oracle applies some stricter rules to datatype conversion than Oracle 9.

It's just that I'd like to know if someone knows any workaround so we don't have to wait for our developer to rebuild his development environment.

Synis, I don not fully understand your posting i its shortness, but fact is that I have quite a few more Delphi/DOA applications developed against Oracle 8/9 having the datatypes of their database fields defined at desing time (I know positively since I wrote them myself) which run flawlessly against Oracle 10, so I don't think this is the problem.

Kind regards

Ingo

 

[Marco Kalter]

Which Direct Oracle Access version are you using?

 

[IngoBfN]

Hello Marco Kalter,

excuse me please, there were some typing errors in my last posting. Of course it was DOA 3.5 (Direct Oracle Access - and not DAO).

Kind regards

Ingo

 

[Marco Kalter]

There is no DOA 3.5. Can you double-check?

 

[IngoBfN]

Our developer told us it was in fact DOA Version 3.3 - I hope this information is correct.

Kind regards

Ingo

 

[Marco Kalter]

That is a very old version. It does not support Oracle10g.