We are using Delphi 7 with ODAC pro 7.00.0.1.
We have 3 Oracle 11g installations, 2 with 11.2.0.1 and 1 with 11.2.0.2
We have created a small application that runs a query. The queries fields are specified in the dfm. When running the query we get the following error message :
Type mismatch for field xxxx expecting: String actual: Memo
The column provoking the error is selected as :
Code: Select all
LTRIM(TO_CHAR(NVL(amt.BAL_TABLE_NR, 0), '000'), ' ') ||
LTRIM(TO_CHAR(NVL(amt.BAL_TABLE_CURRENCY, 0), '0000'), ' ') KEYVALUE_BAL_RATE_TABLE,The problem is this is only occurring with one of the 11.2.0.1 databases but not with the other 2 databases.
We can't see any differences between the databases nor any problems in our code.
We're not sure where the problem could be as it works correctly on 2 of the 3 database.
Does anybody have any ideas ?
Regards
Paul