Unable to query Oracle Timestamp datatype from SQLServer Linked Server via OraOLEDB.
(Doc ID 1262813.1)
Last updated on FEBRUARY 22, 2019
Applies to:Oracle Provider for OLE DB - Version 126.96.36.199 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document