title: Hi I am trying to use the same collection name in my Procedure while declaring the cursor
body: <p>I have defined two cursors in my procedure and trying to give the same collection name.</p>
  
  <pre><code>Error: PLS-00305: previous use of 'ty_cur' conflicts with this use
  
  Cursor cur_1
  IS Select ABC from table tab_1;
  TYPE ty_cur TABLE OF cur_1 %ROWTYPE INDEX BY PLS_INTEGER;
  abc_cur ty_cur;
  
  Cursor cur_2 IS
  Select DEF from table tab_2;
  TYPE ty_cur TABLE OF cur_2 %ROWTYPE INDEX BY PLS_INTEGER;
  abc_cur ty_cur;
  
  Error: PLS-00305: previous use of 'TY_cur' conflicts with this use
  </code></pre>
  
  <p>I have also tried using NESTED TABLE for Cur_2 but the error remained same.</p>
  
  <p>Kindly suggest.</p>