Dates - Oracle 7 vs Oracle 8

[ajurysta]

I am trying to support an Oracle 8 database and an Oracle 7 database with the same version of the code. Everything seems to work just fine except for date fields.

After upgrading a database to Oracle 8, I get an error "size mismatch for field r_date expecting 75 actual 10". The code works fine in Oracle 7. If I change the field size to 75, then the code will no longer work in Oracle 7, but will work fine in Oracle 8.

I am running DOA 3.3.0 for Delphi 4.

 

[Marco Kalter]

From another message in the forum it seems that the to_char function returns a different length in Oracle8 than in Oracle7. Could it be that you are using this function? If so, you can fix it by using the substr function to force it to the required length.

------------------
Marco Kalter
Allround Automations