Suppose I update a LOB column in a remote table from a LOB value in the local table, how do verify whether the update happened successfully? Can I use the DBMS_LOB.COMPARE function to do this? Can I get a remote reference (eg., SELECT b_lob INTO temp FROM tabl@dblink WHERE ...)?
