ERROR: "FnName: Fetch Optimize -- [Informatica][ODBC Oracle Wire Protocol driver][Oracle]ORA-01861: literal does not match format string" while retrieving data from a view that has date fields with date format specifications in CDI
ERROR: "FnName: Fetch Optimize -- [Informatica][ODBC Oracle Wire Protocol driver][Oracle]ORA-01861: literal does not match format string" while retrieving data from a view that has date fields with date format specifications in CDI
![Oracle - SQL Query works fine in SQL Developer but throws error ORA - 01861 Literal does not match the format string in SSIS - Stack Overflow Oracle - SQL Query works fine in SQL Developer but throws error ORA - 01861 Literal does not match the format string in SSIS - Stack Overflow](https://i.stack.imgur.com/A3d17.png)
Oracle - SQL Query works fine in SQL Developer but throws error ORA - 01861 Literal does not match the format string in SSIS - Stack Overflow
![sql - Why am I getting error message: ORA-01861: literal does not match format string when copied from textbook - Stack Overflow sql - Why am I getting error message: ORA-01861: literal does not match format string when copied from textbook - Stack Overflow](https://i.stack.imgur.com/vjffP.jpg)