I have created linked connection in SQL and by which I am connecting Oracle server using OLE DB provider "OraOLEDB.Oracle".
SQL Server = 2008 R2 Oracle = 10g
Normally, When I am executing Insert or Select query it works fine, but some times the same query does not execute well and failure. Same query If I execute again then it works fine.
The Error message is as below.
The OLE DB provider "OraOLEDB.Oracle" for linked server "ABC" could not INSERT INTO table "[ABC]..[M_SCM].[MY_TBL]". err src line: 23 SP_MY_PROCEDURE
Can any one suggest the cause of the issue? and let me know if any solution.