ORA-01862: the numeric value does not match the length of
the format item
- 1 Answers
- 8289 Views
- I also Faced
- E-Mail Answers
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 |
ORA-16001: database already open for read-only access by another instance
ORA-02305: only EXECUTE, DEBUG, and UNDER privileges are valid for types
ORA-16506: out of memory
ORA-01719: outer join operator (+) not allowed in operand of OR or IN
ORA-06258: NETNTT: cannot allocate context area
ORA-01479: last character in the buffer is not Null
PCC-02370: An EXEC TOOLS MESSAGE host variable is not type char
ORA-07215: slsget: getrusage error.
ORA-01299: dictionary string corresponds to a different database incarnation
ORA-01119: error in creating database file 'string'
ORA-07440: WMON process terminated with error
ORA-19830: error from target database: string
Oracle Errors 
