On 14/06/10 12:50, Elias Ghanem wrote:
> SELECT INTO DUMMY DBLINK_EXEC(''CONNECTION_STRING TO DB3',
> ''UPDATE IN_FICHE_PRODUIT SET VALIDE = 1'');
If there's more than one value in that table, an explicit ORDER BY might
help (otherwise you could get the situation where query A will update in
the order 1,2,3 and query B will do 3,2,1 so neither will be able to get
the requested locks until the other query has finished).
Tom