Oracle Error OCI-01859: a non-alphabetic character was found where an alphabetic was expected

Oracle Error Message

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

Reason for the Error

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.

Solution

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