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

Last updated on JULY 05, 2017

Applies to:

Oracle Provider for OLE DB - Version 9.2.0.6 and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
***Checked for relevance on 21-Jun-2012***

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms