title: ORA-01000: maximum open cursors exceeded - java code fails
body: <p>I use loops in my java code to insert rows into my database. Then, I got the error -</p>
  
  <pre><code>ORA-01000: maximum open cursors exceeded
  </code></pre>
  
  <p>I searched a little and saw that closing my prepared statements or statements after adding each row helps to get rid of the error.</p>
  
  <p>But, I need to understand - </p>
  
  <ol>
  <li>what are cursors ?</li>
  <li>Can i change the number of cursors ? If yes, is it a good thing to do ?  </li>
  </ol>