Hi,
  We are updating ORACLE table from SQL Server Stored Procedure using linked servers . It seems to be working fine when I execute the Stored Procedure once. If I run the same stored procedure immediately for multiple times, I am getting the following error.

OLE DB provider 'MSDAORA' could not UPDATE table '[GASLC]..[SYSDBA].[SITEKEYS]'. The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.
[OLE/DB provider returned message: Row cannot be located for updating. Some values may have been changed since it was last read.]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IRowsetChange::SetData returned 0x80040e38: The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.].


Could any one help me?

Thanks
Raj