PLS-00166: bad format for date, time or timestamp literal



PLS-00166: bad format for date, time or timestamp literal..

Answer / guest

Cause: The contents of the date, time or timestamp literal
did not match the expected format 'yyyy-mm-dd
hh24:mi:ssxfftzh:tzm'.

Action: Use a correctly-formatted datetime literal.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

O2I-00127: Illegal INITFUNC name

1 Answers  


PCB-00400: %s

1 Answers  


ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables

1 Answers  


ORA-22634: Error adding new instance to AnyDataSet

1 Answers  


NNL-00296: Controller's local trace level changed from number to number

1 Answers  






ORA-29346: invalid tablespace list

1 Answers  


QSM-01051: no support for rollup when a window function is present on the column

1 Answers  


ORA-32101: cannot create OCI Environment

1 Answers  


ORA-06771: TLI Driver: error reading version

1 Answers  


ORA-32159: Cannot set prefetch options for a null Type

1 Answers  


ORA-28665: table and partition must have same compression attribute

1 Answers  


QSM-02091: mv references a non-repeatable or session-sensitive expression

1 Answers  


Categories