title: ORA-01002: fetch out of sequence while using @transactional
body: <p>When i try to invoke a procedure from my application got an error saying <em>ORA-01002: fetch out of sequence</em> </p>
  
  <p><strong>Technologies used :</strong></p>
  
  <ul>
  <li>Mybatis 3</li>
  <li>Spring MVC</li>
  </ul>
  
  <p>The interesting point here is the error occurs only if i use <strong>@Transactional</strong> (org.springframework.transaction.annotation.Transactional) annotation for the invoking method in service class. If i remove <strong>@Transactional</strong> then there is no ORA error. </p>
  
  <p>I am using @Transactional as i have several DAOs injected into a Service. Please find my code pasted below.</p>
  
  <pre><code>@Transactional
      public boolean saveavgFlyHrs(AverageFlyingHoursReport averageFlyingHoursReport) throws TransactionDataException {
          String status = null;
          boolean isOk = false;
          if(averageFlyingHoursReportDAO.saveavgFlyHrs(averageFlyingHoursReport)) {
              status = averageFlyingHoursReportDAO.updateCheckEff(averageFlyingHoursReport.getSubFleet());
              logger.debug("OUT_STATUS:"+status);
              if(ConstantStringUtil.SUCCESS.equalsIgnoreCase(status)) {
                  isOk = true;
              } else {
                  isOk = false;
              }
          }
          return isOk;
      }
  </code></pre>
  
  <p>Anyone pls help me with this. </p>