ORA-01862: the numeric value does not match the length of
the format item



ORA-01862: the numeric value does not match the length of the format item..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-12018: channel string disabled, job failed on it will be run on another channel

1 Answers  


ORA-24008: queue table string.string must be dropped first

1 Answers  


ORA-08451: invalid specification of DB in picture mask

1 Answers  


QSM-00517: Summary Advisor requires a COMPATIBLE setting of 8.1.0.0 or greater

1 Answers  


CLSR-00004: Error encountered at string, category=number, operation=string, OS error=number

1 Answers  






ORA-13011: value is out of range

1 Answers  


ORA-25241: cannot change correlation ID from string to string without FIRST_MESSAGE option

1 Answers  


ORA-25528: too many candidate MTTRs are specified in _DB_MTTR_SIM_TARGET

1 Answers  


ORA-06572: Function string has out arguments

1 Answers  


ORA-08106: cannot create journal table string.string

1 Answers  


ORA-16749: Resource guard encountered errors in switchover to logical primary

1 Answers  


ORA-09762: sNeXT_instanceName: translation error.

1 Answers  


Categories