I am finishing up a migration to sql 2012 when this error below occurrs when I run the view on the sql 2012 server:
OLE DB provider 'OraOLEDB.Oracle' for linked server 'XXXXX' returned data that does not match expected data length for column '[OraOLEDB.Oracle].SOURCE'. The (maximum) expected data length is 64, while the returned data length is 30.
I am running this view which has been working and still does work on a sql 2008 server.
This view performs an openquery on XXXXX and the SOURCE Column is created as below:
select * from openquery(XXXXX,'
SELECT ''Custom Calc'' source')
This creates a column named 'source' and populates the column with 'Custom Calc'