I HAVE 2 IDENTICAL WINDOWS 2016 SERVERS WITH THE SAME VERSION OF SQL SERVER AND THE SAME OraOLEDB DRIVER AND A LINKED SERVER TO THE SAME ORACLE DATABASE.
THE SQL STATEMENT BELOW WORKS IN ONE BUT GETS THIS ERROR IN THE OTHER:
Msg 7356, Level 16, State 1, Line 116
The OLE DB provider "OraOLEDB.Oracle" for linked server "LSOCSPTS" supplied inconsistent metadata for a column. The column "IS_DESC_OVERRIDEN" (compile-time ordinal 4) of object ""PTS"."DSGN_T_BUNDLE"" was reported to have a "DBCOLUMNFLAGS_ISFIXEDLENGTH" of 16 at compile time and 0 at run time.
I HAVE TRIED EVERYTHING THAT I FOUND ONLINE.
HAS ANYONE EVER SEEN THIS, AND IF YOU DID, HOW DID YOU CORRECT IT?
EXEC [PTS].[PROC_MIGRATE_ORACLE_TABLE] @TableName = N'DSGN_T_BUNDLE',@PrimaryKey = N'DESIGN_BUNDLE_ID_PK',@LinkedServer = N'LSOCSPTS', @Schema = N'PTS'
IF (EXISTS (SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'PTS'
AND TABLE_NAME = 'LLW_T_LLW'))