title: error "ORA-00932: inconsistent datatypes: expected - got CLOB" select join multiple tables
body: <p>i got error when i use yz table that has param field with data type==> CLOB . And this is my query:</p>
  
  <pre><code>WITH t AS
       (SELECT x.order_id,x.customer_name,y.ncli,y.ndem2,y.ndem1,y.nd2,z.status_resume,y.nd1,yz.param
              ,MAX(y.seq) AS seq2
              ,MAX(y.extern_order_status) AS extern
        FROM   t_order_demand x
        JOIN   t_order_log y
        ON     x.order_id = y.order_id
        JOIN   p_catalog_status z
        ON     z.status_code_sc = y.extern_order_status
    JOIN   t_order_demand_eai yz
        ON     yz.order_id = y.order_id
        AND    y.order_id =1294
        GROUP  BY x.order_id,x.customer_name,y.ncli,y.ndem2,y.ndem1,y.nd2,y.nd1,z.status_resume,yz.param)
      SELECT *
      FROM   t
      WHERE  (t.seq2 || t.extern) IN (SELECT MAX(tt.seq2 || tt.extern) FROM t tt)
  </code></pre>
  
  <p>and this is the error:</p>
  
  <pre><code>ORA-00932: inconsistent datatypes: expected - got CLOB
  00932. 00000 -  "inconsistent datatypes: expected %s got %s"
  </code></pre>
  
  <p>anybody can help me to fix this error? thanks...</p>