Threw out [ADT005324E] error while sql developer executes fine

TJ (32 posts)
May 8, 2020 03:34 PM
Accepted Answer

Hi,

I am executing an full join statement in database operation, which threw me Failed to execute SQL command at line 17: ORA-01861: literal does not match format string
ORA-01861: literal does not match format string [ADT005324E] while it runs fine in sql developer.

Please advice what this is different than sql developer.

Thanks 

Bill Staff (599 posts)
May 12, 2020 06:09 PM
Accepted Answer
It's possible that adTempus is constructing the query incorrectly, or that SQL Developer does different preprocessing of strings. I would need to see the query you are executing. If you don't want to post it publicly you can either open a support case or upload it here in a text file, which will not be publicly visible.

Replies are disabled for this topic.