title: ora 22992 on a LOB field i am not using
body: <p>I have the following simple oracle query:</p>
  
  <pre><code>select A.field
  from table1 A
  left join table2@remotedb B on A.id = B.id
  </code></pre>
  
  <p>Where table B has a BLOB field</p>
  
  <p>It runs fine</p>
  
  <p>If i add a concat to the select:</p>
  
  <pre><code>select A.field||'x'
  from table1 A
  left join table2@remotedb B on A.id = B.id
  </code></pre>
  
  <p>I get the following error: 
  "ora-22992 cannot use lob locators selected from remote tables"</p>
  
  <p>Why adding a concat to a filed which isn't the LOB file is giving me this  error?!?</p>
  
  <p>What can i do to avoid it?</p>