Last week, we moved a database from one test server to a new test server. We're now receiving this error message when we attempt to execute a Table Valued Function that accesses Oracle data via a linked server. Our DBA has confirmed that the settings for the Linked Server matches those on the original test server as well as the linked server in Production. Any ideas?
Msg 7356, Level 16, State 1, Line 5
The OLE DB provider "OraOLEDB.Oracle" for linked server "[Server Name Deleted]" supplied inconsistent metadata for a column. The column "[Column Name Deleted]" (compile-time ordinal 27) of object "Schema & Table Names Deleted" was reported to have a "DBCOLUMNFLAGS_ISFIXEDLENGTH" of 16 at compile time and 0 at run time.
Did you also verify the version and configuration of the Oracle provider? Provider/Driver versions is another one that can cause that error.
Sue