Question

5
Replies
488
Views
Close popover
Anuj Newrekar (AnujN348)
Infosys

Infosys
AU
AnujN348 Member since 2016 75 posts
Infosys
Posted: June 19, 2017
Last activity: October 16, 2018
Closed
Solved

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.

Low-Code App Development Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.