I configured linked server using "Oracle Provider for OLE DB" and tested connection. Everything works fine. When I execute insert command, the problem arises.

System Configuration:

Windows 7 Ultimate 64 bit

SQL Server 2008 R2 Standard Edition 64 bit

Oracle 11gR2 Client 64 bit

ODAC 11.2.0.3.2.0 64 bit

I think Microsoft OLE DB provider for Oracle will work. But I can't get that option while configuring linked server. So I need to install Microsoft OLE DB provider for Oracle.

Please anyone help.

Thanks,