Msg 7330, Level 16, State 2, Line 1 Cannot fetch a row from OLE DB provider "OraOLEDB.Oracle" for li

Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "OraOLEDB.Oracle" for linked server "SRSPROD_ORA" reported an error. The provider reported an unexpected catastrophic failure.

Msg 7330, Level 16, State 2, Line 1

Cannot fetch a row from OLE DB provider "OraOLEDB.Oracle" for linked server "SRSPROD_ORA".

Error occurs when attempting UPDATE of a remote Oracle (11.1.0.7 on Solaris 10) table via a OLE DB (11.1.0.6) database link from MS SQL Server 2005 SP2 on Windows Server 2003 Standard).

SQL is:

update LINK..SIDE.SRS_OCI

  set oci_pams = 'N'

  where oci_stuc = '11648468'

Using OpenQuery from the SQL Server seems to work though:

UPDATE OPENQUERY(LINK, 'select * from SIDE.SRS_OCI where oci_stuc = ''11648468''')