You proposed a work-around for using select openquery but not when using insert openquery. I'd appreciate if you could suggest a work around when inserting into a timestamp column from SQL server using Oracle Linked Server. Here is my syntax:

insert OPENQUERY(OracleLinkedServer, 'SELECT [Other Columns], TimeStampColumn FROM OracleSchema.OracleTable')

select @data, CONVERT(datetime2(7),'2007-05-02T19:58:47.1234567')

TimeStampColumn in Oracle has a datatype of TIMESTAMP(6). I tried all the following to insert timestamps in Oracle but I get the same error in all cases:

Error:

OLE DB provider "MSDAORA" for linked server "" returned

message "Oracle error occurred, but error message could not be retrieved

from Oracle.".

OLE DB provider "MSDAORA" for linked server "" returned

message "Data type is not supported.".

Msg 7321, Level 16, State 2, Line 5

An error occurred while preparing the query "" for execution against OLE DB provider "MSDAORA" for linked server "".