SQl server version is 2016 SP2 enterprise.
Created a link server name CRMLINK.
oracle driver installed :12.2 64bit
When do a sql I am having error
select * from CRMLINK.<schema>.tablename
+++++++++++++++++++++++++++++++++++++
Msg 7356, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "CRMLINK" supplied inconsistent metadata for a column. The column "MOD_DATE" (compile-time ordinal 6) of object ""CRMLINK"."crm001"" was reported to have a "DBCOLUMNFLAGS_ISFIXEDLENGTH" of 16 at compile time and 0 at run time.
+++++++++++++++++++++++++++++++++++++++
But connection is success when we use in this way OPENQUERY
SELECT from OPENQUERY(CRMLINK,'select from <schema>.tablename')
+++++++++++++++++++++++++++++
Developers are need to access first way not using openquery.
Any one knows why this is happening
Thanks