Insert into Oracle 10g from MS SQL Server with pass through openquery

I am attempting to insert data across a DB link from an MS SQL Server 2008 into and Oracle 11g server using a pass through insert:

insert into openquery(ORACLE,'select varchar2_1,varchar2_2, number1 from table1')
   select varchar_1, varchar_2, integer_1 from mssql_table;

When I try and execute this开发者_如何学C I get and error saying that the data violates the schema.

Error:
The OLE DB provider "MSDAORA" for linked server "ORACLE" could not INSERT INTO table "[MSDAORA]" because of column "VARCHAR2_1". The data value violated the schema for the column.

I searched around google and stackoverflow but could not seem to find a specific solution to this problem. fyi: I cannot change the schema in the oracle DB.

Any help would be greatly appreciated.

Check the lengths of the data in varchar_2. Can the data fit into the oracle column varchar2_1?