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

NNL-00563: timed_query [<timestamp>] : query all objects in the Names server's cache

1 Answers  


ORA-38490: invalid name: quotes do not match

1 Answers  


TNS-00028: INTCTL: Could not resolve Connection Manager's name/address

1 Answers  


QSM-02022: aggregate selections

1 Answers  


when i open the data base the data base gives error as initalishing or terminating how i log into data base

1 Answers  






RMAN-06060: WARNING: skipping datafile compromises tablespace string recoverability

1 Answers  


ORA-13283: failure to get new geometry object for conversion in place

1 Answers  


ORA-16402: ONDEMAND archival requires FAL_CLIENT and FAL_SERVER support

1 Answers  


TNS-12158: TNS:could not initialize parameter subsystem

1 Answers  


ORA-25205: the QUEUE string.string does not exist

1 Answers  


ORA-19656: cannot backup, copy, or delete online log string

1 Answers  


TNS-01154: SID detected in old format that is no longer supported

1 Answers  


Categories