• Aatish Patel (11/25/2013)


    I create a linked server to Oracle in SQL 2008. tested the connection and it tests successfully.

    When I try to query

    SELECT top 10 * FROM [linkedserver]..[abc].[persons]

    GO

    it fails with following error :

    Msg 7354, Level 16, State 1, Line 1

    The OLE DB provider "OraOLEDB.Oracle" for linked server "W263UW" supplied invalid metadata for column "INACTIVE_TS".

    The data type is not supported.

    Pls help with this.

    in Oracle, what is the datatype for the column INACTIVE_TS in the [persons] table?

    if it's a TIMESTAMP, look at this post:

    http://webcache.googleusercontent.com/search?q=cache:6PcBw8RwF54J:drewstechnotes.blogspot.com/2010/05/easy-workaround-for-oracle-linked.html+&cd=1&hl=en&ct=clnk&gl=us

    I've seen issues where an "old" drivers for Oracle version 9 is used agaisnt an Oracle version 10/11 database, and returns this kind of error for BLOB/CLOB columns;

    the solution was to get a more updated Oracle driver installed on the SQL server to address the issue.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!