InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 16:37:50 GMT20http://www.sqlservercentral.com/Forums/Topic1391984-391-1.aspxI am afraid not. I had to use the open query workaround. :(Tue, 21 May 2013 14:23:52 GMTkats99http://www.sqlservercentral.com/Forums/Topic1391984-391-1.aspxDid you ever resolve this issue with the linked server to Oracle?Tue, 21 May 2013 14:05:43 GMTmichaelkinlbhttp://www.sqlservercentral.com/Forums/Topic1391984-391-1.aspxYs I did thankyou but it does not applyTue, 04 Dec 2012 04:18:14 GMTkats99http://www.sqlservercentral.com/Forums/Topic1391984-391-1.aspxHave you checked this link?http://support.microsoft.com/kb/251238Tue, 04 Dec 2012 04:15:50 GMTarunyadav007http://www.sqlservercentral.com/Forums/Topic1391984-391-1.aspxI am looking at the collations on the linked server to see if that helpsHere are my configurations:Oracle 11gNLS_LANGUAGE = AMERICANNLS_TERRITORY = AMERICANLS_CHARACTERSET = WE8ISO8859P15NLS_NCHAR_CHARACTERSET = AL16UTF16SQL 2008 R2 RTM x64Linked Server Provider - OraOLEDB.OracleLinked Server settings - Collation Compatible = False, Use Remote Collation = True, Collation Name = SQL_Latin1_General_CP1_CI_ASI have also tried with Collation Compatible = True and no Collation NameAny help would be greatThanksTue, 04 Dec 2012 04:07:12 GMTkats99http://www.sqlservercentral.com/Forums/Topic1391984-391-1.aspxHiI have created a linked server to Oracle using the Oracle OLE DB provider "ORAOLEDB.ORACLE" from SQL 2008. I can query the Oracle database using OPENQUERY but when I try a simple SELECT COUNT(*) from LK_ORA..USR.TAB1 I get an error:Msg 7356, Level 16, State 1, Line 1The OLE DB provider "ORAOLEDB.ORACLE" for linked server "LK_ORA" supplied inconsistent metadata for a column. The column "COL_CODE" (compile-time ordinal 1) of object ""USR"."TAB1"" was reported to have a "LENGTH" of 12 at compile time and 24 at run time.I've found an article that says when SQL Server retrieves metadata from Oracle in order to compile the query, Oracle reports the data type to be varchar(255), but when it actually returns the data, the data type is in fact nvarchar(255). (But it may not be called nvarchar in Oracle.)Anyone know how to get around this? I've tried various options on my linked server connection in SQL with no luck so farMany ThanksMon, 03 Dec 2012 08:35:48 GMTkats99