title: ODI Interface execution error
body: <p>I have created a simple ODI interface that will read from a flat file and insert into a Oracle table. However, when i execute the interface, it fails in one of the steps giving the error message : ORA-00936: missing expression</p>
  
  <p>The code generated by this step is :-</p>
  
  <pre><code>  /* DETECTION_STRATEGY = NOT_EXISTS */
  
  
  
  insert /*+ append */ into ODI_STAGE.I$_CSV_TEST 
    (
      FIRSTNAME,
      LASTNAME,
      IND_UPDATE
  )
  select 
  FIRSTNAME,
      LASTNAME,
      IND_UPDATE
   from (
  
  
  
  select   
  
  
  
  C1_FIRSTNAME FIRSTNAME,
  C2_LASTNAME LASTNAME,
  
  'I' IND_UPDATE
  
  
  from    ODI_STAGE.C$_0CSV_TEST
  where   (1=1)
  
  
  
  ) S
  where NOT EXISTS 
      ( select 1 from ODI_STAGE.CSV_TEST T
      where
  
           and ((T.FIRSTNAME = S.FIRSTNAME) or (T.FIRSTNAME IS NULL and S.FIRSTNAME IS NULL)) and
          ((T.LASTNAME = S.LASTNAME) or (T.LASTNAME IS NULL and S.LASTNAME IS NULL))
          )
  </code></pre>
  
  <p>Can some one please suggest what is wrong with this query? As I don't see any syntactical issue with it.</p>