Database Isuue

[Mahrous]

I am getting the error: Internal : Could not execute code stage because exception thrown by code stage: ORA-01861: literal does not match format string
ORA-01861: literal does not match format string

While the query works fine in the database. In fact, I get the same error when I try to run any query, does anyone have an idea how to solve this?

[Jrwork]

If you are dealing with dates, the error may occur because the date string you provided does not match the format expected by the database. Oracle uses the format 'DD-MON-YYYY' or 'YYYY-MM-DD', depending on the instance configuration.

Can you share the query?

@Mahrous 

[faheemsd]

@Mahrous 
Could you please explain the scenario for more understanding?

If possible, please share query as well.

[Mahrous]

Hi all,

I changed the Oracle object that I was using. I was using the OLED8 object and I tried the Oracle MDA, and it is now working fine.

The problem I had was not really related to dates, as I was trying to run any query in general and I was getting the same error as well. I was not able to identify where the problem was. However, it is working with the new Object now.

Thank you.

[Jrwork]

@Mahrous Okay, if you have any questions, I'm at your disposal. Have a good week.