title: could not execute native bulk manipulation query
body: <p>I am trying to implement a "if exists, update, otherwise, insert" data access method in NHibernate. My database is Oracle 10g.</p>
  
  <p>I am getting this "could not execute native bulk manipulation query" error when try to run this code, if I run the insert or update individualy, it works just fine.</p>
  
  <p>Thanks!</p>
  
  <pre><code>string sql = @"DECLARE
                  CntOfRow Number(10,0);
                BEGIN
                      SELECT count(*)
                      INTO CntOfRow
                      FROM Table1
                      WHERE 
                          QueID=:QueID
  
                      IF CntOfRow=0 THEN
                          INSERT INTO Table1 ...;
                      ELSE
                          UPDATE Table1 ... ;
                      END IF;
                  END;";
  
  
              INHibernateSession session = NHibernateSessionManager.Instance.Session;
  
              try
              {
                  session.BeginTransaction();
                  ISQLQuery query = session.GetISession().CreateSQLQuery(sql.Replace(System.Environment.NewLine, " "));
                  query.SetParameter("QueID", queID);
                  query.ExecuteUpdate();
                  session.CommitTransaction();
              }
              catch (Exception ex)
              {
                  session.RollbackTransaction();
                  throw;
              }
  </code></pre>