Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 21c
  • 19c
  • 19c
Updated
Jun 24, 2024

OCI-01862

the numeric value does not match the length of the format item

Cause

When the FX and FM format codes are specified for an input date, then the number of digits must be exactly the number specified by the format code. For example, 9 will not match the format specifier DD but 09 will.


Action

Correct the input date or turn off the FX or FM format specifier in the format string.