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-00136: Did not register product/facility for TNS error message

1 Answers  


PCC-00102: FOR UPDATE is an Oracle extension

1 Answers  


ORA-00384: Insufficient memory to grow cache

1 Answers  


ORA-01552: cannot use system rollback segment for non-system tablespace 'string'

1 Answers  


ORA-31116: Tablespace not specified correctly

1 Answers  






ORA-37084: Output valueset string must match string's dimesnionality

1 Answers  


PCC-02388: Arrays not allowed in FROM/WHERE clause of SELECT statement

1 Answers  


ORA-30742: cannot grant SELECT privilege WITH HIERARCHY OPTION on this object

1 Answers  


ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

1 Answers   CGI,


ORA-30727: duplicate referential constraint for a REF column

1 Answers  


ORA-32001: write to SPFILE requested but no SPFILE specified at startup

1 Answers  


PLS-00391: undefined column 'string' in UPDATE statement

1 Answers  


Categories