title: SQL Server 2008: INSERT INTO through Linked Server to Oracle 11g table with TIMESTAMP(6) column
body: <p>I'm trying to insert a row with TIMESTAMP(6) column in an Oracle 11g table from SQL Server 2008 script, through Linked Server.</p>
  
  <p>This is what I tried so far:</p>
  
  <pre><code>INSERT INTO LinkedServer..Schema.Table(TimeStampColumn) 
  VALUES(CONVERT(DATE, '2013-08-07'));
  
  INSERT INTO LinkedServer..Schema.Table(TimeStampColumn) 
  VALUES(CONVERT(DATETIME, '2013-08-07 12:12:12.000001'));
  
  INSERT INTO LinkedServer..Schema.Table(TimeStampColumn) 
  VALUES(CONVERT(TIMESTAMP, '2013-08-07 12:12:12.000001'));
  </code></pre>
  
  <p>and many combinations, every time I get this error:</p>
  
  <blockquote>
    <p>The OLE DB provider "OraOLEDB.Oracle" for linked server "LinkedServer" supplied invalid metadata for column "TimeStampColumn". The data type is not supported.</p>
  </blockquote>
  
  <p>Is this possible? </p>
  
  <p>How can I convert SQL Server's <code>varchar</code> or <code>datetime</code> value to Oracle <code>timestamp(6)</code> data type?</p>
  
  <p>Thanks a lot!</p>