Oracle Error OCI-01861: literal does not match format string

Oracle Error Message

OCI-01861: literal does not match format string

Reason for the Error

Literals in the input must be the same length as literals in the format string (with the exception of leading whitespace). If the “FX” modifier has been toggled on, the literal must match exactly, with no extra whitespace.

Solution

Correct the format string to match the literal.