Question

5
Replies
465
Views
AnujN348 Member since 2016 73 posts
Infosys
Posted: 3 years ago
Last activity: 2 years 4 months ago
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
Share this page LinkedIn