Friday, June 3, 2016

Oracle 12 SQL SERVER link Error JD Edwards



The OLE DB provider "OraOLEDB.Oracle" for linked server "JDED1" supplied inconsistent metadata for a column. The column "MCMCU" (compile-time ordinal 1) of object ""CRPDTA"."F0006"" was reported to have a "LENGTH" of 12 at compile time and 24 at run time.



following is working


Select * from OPENQUERY(JDED1,'SELECT substr(MCMCU,1,12) MCMCU,substr(MCDL01,1,60)MCDL01  FROM CRPDTA.F0006') ORDER BY 1;

No comments: