title: linked server problem at sql server while connecting to oracle dbms
body: <p>I have created a linked-server definition according to the article at :<br>
  <a href="http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/" rel="nofollow">http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/</a></p>
  
  <p>My aim is to transfer rows to tables at Oracle 11gR2.</p>
  
  <p>After creating linked server, whenever I try to select a table using a query like :</p>
  
  <pre><code>SELECT *
  FROM [192.168.1.188]..[ESIPARIS].[T_ERROR_LOG]
  </code></pre>
  
  <p>I get the error below : </p>
  
  <pre><code>Msg 7356, Level 16, State 1, Line 1
  The OLE DB provider "OraOLEDB.Oracle" for linked server "192.168.1.188"
  supplied inconsistent metadata for a column. The column "EVENT_OBJECT"
  (compile-time ordinal 2) of object ""ESIPARIS"."T_ERROR_LOG"" was reported
  to have a "LENGTH" of 50 at compile time and 100 at run time.
  </code></pre>
  
  <p>One more thing is that it duplicates field names whenever a select statment is prepared by "Sql Server Management Studio", some fields are duplicated as below :</p>
  
  <pre><code>SELECT [EVENT_DATE]
        ,[EVENT_DATE]
        ,[EVENT_DATE]
        ,[EVENT_DATE]
        ,[EVENT_OBJECT]
        ,[EVENT_OBJECT]
        ,[EVENT_OBJECT]
        ,[EVENT_OBJECT]
        ,[MESSAGE]
        ,[MESSAGE]
        ,[MESSAGE]
        ,[MESSAGE]
        ,[EVENT_ID]
    FROM [192.168.1.188]..[ESIPARIS].[T_ERROR_LOG]
  </code></pre>
  
  <p>I would be very happy to hear from you about any ideas, thank you for your concern,</p>
  
  <p>Best Regards,</p>
  
  <p>Kayhan YÜKSEL</p>