Unable to query Oracle Timestamp datatype from SQLServer Linked Server via OraOLEDB.
Last updated on JULY 05, 2017
Applies to:Oracle Provider for OLE DB - Version 22.214.171.124 and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
***Checked for relevance on 21-Jun-2012***
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:
- Create the following table in Oracle:
create table tstab1(c1 timestamp);
insert into tstab1 values(systimestamp);
- Create a Linked Server following the directions in <Note 191368.1>
- Issue the following query in SQL Management Studio (assuming you've named the link SCOTTLINK)
SELECT * FROM SCOTTLINK..SCOTT.TSTAB1
- 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.
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