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

TNS-01062: The db subagent is already running.

1 Answers  


IMP-00085: multiple input files specified for unbounded export file

1 Answers  


TNS-00545: parameter retrieval failure

1 Answers  


PCC-00012: Not in a declare section at line number in file string

1 Answers  


TNS-02524: Authentication: privilege check failed

1 Answers  






RMAN-05515: Duplicate for standby does not allow the use of SET UNTIL

1 Answers  


NNL-00987: Authoritative answers when authority: number

1 Answers  


ORA-25003: cannot change NEW values for this column type in trigger

1 Answers  


ORA-12324: cannot use the ROM: link type on a private database link

1 Answers  


ORA-02322: failure in accessing storage table of the nested table column

1 Answers  


PCC-02326: illegal structure reference operation

1 Answers  


DRG-12900: Operation:string for index: string has already been started

1 Answers  


Categories