Thursday 19 January 2012

ORA-01859: a non-alphabetic character was found where an alphabetic was expected

ORA-01859: a non-alphabetic character was found where an alphabetic was expected

Cause: The input data to be converted using a date format model was incorrect. The input data did not contain a letter where a letter was required by the format model.

Action: Fix the input data or the date format model to make sure the elements match in number and type. Then retry the operation.

No comments:

Post a Comment