Unable to query Oracle Timestamp datatype from SQLServer Linked Server via OraOLEDB. (Doc ID 1262813.1)

Symptoms

Trying to query a column of Timestamp datatype via SQLServer and Oracle's OLEDB Provider results in the following error:

Msg 7354, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "<linked_server_name>" supplied invalid metadata for column "<colum_name>". The data type is not supported.


The behavior can be reproduced with the following steps:

1. Create the following table in Oracle:
   
   
   create table tstab1(c1 timestamp);
   insert into tstab1 values(systimestamp);
   commit;
2. Create a Linked Server following the directions in <Note 191368.1>
3. Issue the following query in SQL Management Studio (assuming you've named the link SCOTTLINK)
   
   
   SELECT * FROM SCOTTLINK..SCOTT.TSTAB1
4. The output is as follows:
   
   
   The OLE DB provider "OraOLEDB.Oracle" for linked server "SCOTTLINK" supplied invalid metadata for column "C1". The data type is not supported.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.