Hi,

We have a problem with the linked server, ole db and statement UPDATE.

We have many remote servers with linked servers. There are Sql-Server 7.0 and
Oracle Server.
When we want to make update, we made in the next way:
UPDATE OPENQUERY(LinkedServerName,"Select * from t_table where id=1&#34
SET field='01'.

This statement is very fast against Sql-Server, faster than the four names
sintax :
Update LinkedServerName.DatabaseName.dbo.Table set field='01' where id=1.
(This sintax performs a
remote scan very slow).
The problem is when the remote server is a Oracle Server,
the statement :

UPDATE OPENQUERY(LinkedServerName,"Select * from t_table where id=1&#34
SET field='01' return the error:

OLE DB provider 'MSDAORA' supplied inconsistent metadata.
The object was missing expected column 'Bmk1000'.

What is the column Bmk1000???
Can help me anibody???

Regards