Inserting data into an Oracle table

[Packermann]

I am having problems inserting into an Oracle table using a linked server.<br><br>The problem is that there columns in the Oracle table that have datatypes that are not supported by Microsoft. Even if the problem column is not specified in the INSERT clause, I still receive an error that the column's datatype is not supported. Can anybody help?

 

[BootMeUp]

I haven't tried this, but what I would do is change the datatype in SQLServer to 'varchar' or 'char' (if possible).<br>If this works, then you have the data in Oracle and can possibly do a convert on it.<br>Good Luck