title: Parameterized cursor within a cursor loop?
body: <ol>
  <li>I have a parameterized cursor &quot;cur_lovs(parm1, parm2, parm3)&quot;</li>
  <li>I want to loop and inside the loop, I wanna use the same cursor &quot;cur_lovs(parm1, parm2, valOfMainLoop)&quot; with the values getting from main loop.</li>
  </ol>
  <p>If I try this I am getting the below error:</p>
  <blockquote>
  <p>ORA-06511: PL/SQL: cursor already open</p>
  </blockquote>
  <p>is there any way to do this?</p>