ORA-01861: literal does not match format string



ORA-01861: literal does not match format string..

Answer / guest

Cause: 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.

Action: Correct the format string to match the literal.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

TNS-04208: Trace Assistant Internal ERROR: Fatal

1 Answers  


ORA-36820: (XSLMINFO00) The LIMITMAPINFO function encountered an error while parsing the LIMITMAP.

1 Answers  


ORA-16624: broker protocol version mismatch detected

1 Answers  


ORA-19759: block change tracking is not enabled

1 Answers  


ORA-13143: invalid POLYGON window definition

1 Answers  






ORA-01906: BACKUP keyword expected

1 Answers  


TNS-00207: Uptime : number days number hr. number min. number sec

1 Answers  


ORA-25407: connection terminated

1 Answers  


EXP-00030: Unexpected End-Of-File encountered while reading input

1 Answers  


TNS-01169: The listener has not recognized the password

1 Answers  


ORA-29347: Tablespace name validation failed - failed to match tablespace 'string'

1 Answers  


ORA-12919: Can not drop the default permanent tablespace

1 Answers  


Categories