Forum Stats

  • 3,767,809 Users
  • 2,252,719 Discussions
  • 7,874,333 Comments

Discussions

DBCOLUMNFLAGS_ISFIXEDLENGTH

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'))