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

O2F-00321: Error opening the OUTTYPE file for writing

1 Answers  


ORA-39139: Data Pump does not support XMLSchema objects. string will be skipped.

1 Answers  


ORA-37114: OLAP API bootstrap error: (string)

1 Answers  


LSX-00159: list content of multiple simple types is not allowed

1 Answers  


ORA-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.

1 Answers  






ORA-13701: Snapshot pair [string, string] seems to be specified in reverse order.

1 Answers  


ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

1 Answers  


ORA-07850: sllfop: bad option

1 Answers  


PLS-00509: Implementation Restriction : Pass a returned record to a temporary identifier before selecting a field

1 Answers  


ORA-29366: invalid CONSUMER_GROUP argument specified

1 Answers  


NZE-29240: the cryptographic engine does not recognize the algorithm

1 Answers  


ORA-29833: indextype does not exist

1 Answers  


Categories