Here is what worked for me. Remote SQL on a linked server.

declare @value1 int, @value2 int

DECLARE @v1 datetime

SET @v1 = CONVERT(datetime,getdate() )

EXEC('INSERT INTO SCHEMANAME.TABLENAME(RegularCol1, RegularCol2, TIMESTAMPColumnInOracle )

...

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...