Oracle Database 12c New Features

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.