Connect Sql error
i get this error : "there was a problem getting a list code: 1861 SQLState: 22008 Message: ORA-01861: literal does not match format string"
on running this connect sql in a RDB-list step:
select object_name,object_type,created,last_ddl_time,timestamp,STATUS AS "Status"
from all_objects
where 1=1
and owner = 'CPE_BPRMS'
and last_ddl_time >= {.FromDate}
order by last_ddl_time desc
Any suggestions would be appreciated. Thanks.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
BUPA
AU
Hi Anuj,
Pls try passing the date value as to_date function argument. Pls note I am unable to test this and confirm the below is working.
Ex: to_date({.YorDateProp},'dd/mm/yyyy')
BUPA
AU
Hi Anuj,
Pls try with the below SQL. In my DB it is working fine.
select object_name,object_type,created,last_ddl_time,timestamp,STATUS AS "Status"
from all_objects
where 1=1
and owner = 'XXXXXX'
and last_ddl_time >= to_date('07/06/2017','dd/mm/yyyy')
order by last_ddl_time desc
The literal is not matching only for Date field. So you have to take care of the same in your code.
Accepted Solution
BUPA
AU
Hi Anuj,
Pls try passing the date value as to_date function argument. Pls note I am unable to test this and confirm the below is working.
Ex: to_date({.YorDateProp},'dd/mm/yyyy')
CBA
IN
This article didn't tell. Could you please help on the below error. any suggestions?
There was a problem getting a list: code: 1861 SQLState: 22008 Message: ORA-01861: literal does not match format string ORA-06512: at line 1
Passing parameter as Job date (DateTime property in Pega side and Date format in Oracle side)
Tried solution: by changing property Job date to Date also . No luck
Please help me out of here