Oracle ORA-1843 and SQL-2203
Error Troubleshooting
Error Messages:
ORA-1843 - not a valid date
SQL-2203 - numeric value out of range
If these errors occur while inserting data, check to make sure that
a FileMaker Time format field is not being inserted into an Oracle Date
field. One option which can be used to resolve this problem is to create
a new FileMaker text field for storing the Date and Time fields together
in the Oracle Date/Time format. The Date/Time format should be 'YYYY-MM-DD
HH24:MI:SS' in order to match the Oracle NLS_LANG setting specified
in the files created by FmPro Migrator. Create a FileMaker script using
the Insert Calculated Result script step in order to calculate this
value for all records of the FileMaker database. Once this calculation
has completed, make a copy of the FileMaker database then delete the
original Date and Time format fields from the FileMaker database. Use
FmPro Migrator to re-generate the conversion scripts based upon the
newly modified FileMaker database file.
