Type mismatch String x Memo

[Adelson Smania]

Hi.

I'm getting a strange problems, using DOA 4 for Delphi 5, in a 9.2.0.4 Oracle Database. In all our customers, everything is working fine. But, in one of them, I'm getting a "Type mismatch for field 'FieldName', expecting: String actual: Memo".

Any ideas of what can cause that?

Thanks.

 

[Marco Kalter]

Perhaps the underlying database column is different in this customer's database?

 

[Adelson Smania]

Hi, Marco.

No, the columns are exactly the same. And it's a "generic" error, that occurs in several columns, of diferent tables. The problem occours after upgrading DOA version from 3.x to 4.x.

 

[Marco Kalter]

But I assume that these customers use the same appliction version, built with Direct Oracle Access 4.x? And that one of them is experiencing the error?

If so, and if the column sizes are the same, please ensure that they use the same length semantics (e.g. one databases use byte length semantics, and another uses character length semantics).

There must be some difference.

 

[Adelson Smania]

Hi, Marco.

Our DBA has found the problem. There's a bug in Oracle 9.2.0.4 that causes the wrong datatype problem, but that depends of some Oracle parameters.

We hadn't faced that problem in DOA 3.x because we forced OCI7 mode.

Thanks for your attention.

 

[Marco Kalter]

Okay, thanks for letting me know.