Oracle DBA, How To, Error, Cause and Action

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

Thanks for your comment.