Question

5
Replies
504
Views
Anuj Newrekar (AnujN348)
Infosys

Infosys
AU
AnujN348 Member since 2016 75 posts
Infosys
Posted: June 19, 2017
Last activity: October 16, 2018
Posted: 19 Jun 2017 3:45 EDT
Last activity: 16 Oct 2018 12:03 EDT
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, 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.