Thursday 15 March 2012

ORA-01861: literal does not match format string

When we are running Concurrent Programs  Executable Type is PL/Sql Procedure with Date Parameter using FND_STANDARD_DATE as a Value set , That time might be we will get the following error.


ORA-01861: literal does not match format string

To avoid this error , Convert the date format as per the below format.


to_date(p_end_date,'RRRR/MM/DD HH24:MI:SS')


Note: Define Datatype of Parameter is Varchar2.



No comments:

Post a Comment