title: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
body: <p>I m getting the below SQL exception and I don't know what's the root cause for this exception? I am also closing db connection and statement too. </p>
  
  <pre><code>java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
  ORA-01000: maximum open cursors exceeded
  ORA-00604: error occurred at recursive SQL level 1
  ORA-01000: maximum open cursors exceeded
  ORA-01000: maximum open cursors exceeded
  </code></pre>
  
  <p>Following is my code:</p>
  
  <pre><code> while(true)
   {
  
     Statement stmt2 = conn1.createStatement();
     ResultSet rs2 = null;
  
     int rec_count=0;
     rs2 = stmt2.executeQuery("select count(*) as cnt from   some_table");                                  
      while(rs2.next())
     {
       rec_count = rs2.getInt("cnt");
     }
  
     if(rec_count&gt;0)
     {
       update_qry_b_trg1 = "update some_table set to_be_triggered=1,algo_status='D',dealer_id='HD001',price_trig_date=sysdate where buy_sell = 'SELL' and ordertype = 'BNLD' and to_be_triggered = 0 and algo_status = 'P' and Mod(group_ref_no,5)="+th_id;
  
     String final_qry = "BEGIN \n"+update_qry_b_trg1+";\n"+";\n END;";
  
     int rows = stmt1.executeUpdate(final_qry);
     stmt1.close();
     }
  
     rs2.close();
     stmt2.close();
  
     }
  </code></pre>