I realize this might be out of scope for the forum but figured it's worth a shot...
I have a process where I copy data from a table in our local SQL Server instance to a remote Oracle table via Linked Server. I can do the INSERT without any issue at all.
I can also DELETE from the remote Oracle table - so I know I have permission to do so. The problem is if I try to use a date filter on the DELETE command - for example:
delete from [REMOTESERVER.COMPANY.COM:1234]..[DW_STG_OWNER].[FACT_BOOKING_INCR_STG]
where INCREMENTAL_RUNTIME = '2021-07-26 11:06:00.0000000'
Throws the following error:
OLE DB provider "OraOLEDB.Oracle" for linked server "REMOTESERVER.COMPANY.COM:1234" returned message "The system cannot find message text for message number 0x80040e21 in the message file for OraOLEDB.".
Msg 7345, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "REMOTESERVER.COMPANY.COM:1234" could not delete from table ""DW_STG_OWNER"."FACT_BOOKING_INCR_STG"". There was a recoverable, provider-specific error, such as an RPC failure.
As best I can find, the error code 0x80040e21 indicates a data type mismatch. I believe the data type on their end is DATETIME is there a way I can cast the dates on my end to avoid this error?