7 Replies Latest reply: Nov 5, 2017 3:54 AM by Vineeth Pujari RSS

    SQL Query not working with OLE DB

    khaled ab

      Hello Community,

       

      i have been trying this simple sql query while using OLE DB but it was throwing errors  but when i changed the connection to ODBC

      it worked just fine

       

      here is the query that i have been working on :

       

      Sql SELECT *

      FROM APPSRO.MTL_SYSTEM_ITEMS_B

      WHERE TO_DATE(LAST_UPDATE_DATE,'DD-MON-RR') >= '$(Last_updated_Date)';

       

      does anyone know why its working with odbc but not oledb ?

      do i have to apply modification in order to get it working with oledb ?

       

      Sincerely