Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I don't think you need to change the code.
have you checked your OLEDB Driver? are you able to connect to the database server using OLEDB?
@varun
i am able to connect to the database and fetch the data but with out Where clause.
Sincerely
can you post screenshots of the error mesg?
The below screen shot while using oledb:
i have tried to change the format of the date passed to the variable in multiple ways but it was of no use.
the below screen shot while using odbc
Have you checked the below threads?
OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string
remove the single quotes
$(Last_updated_Date)
https://www.techonthenet.com/oracle/errors/ora01861.php