title: How to update only rows selected in SYS_REFCURSOR
body: <p>I want to update only the rows selected in a cursor inside a procedure and return that cursor. My procedure is below:</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE P_FETCH_TEST
  (OUT_CURSOR OUT SYS_REFCURSOR)
  AS 
  BEGIN
  
    OPEN OUT_CURSOR FOR 
      SELECT UNIQUE_ID , COMMENTS , STATUS FROM T_TEST WHERE STATUS=0
  
  END P_FETCH_TEST;
  </code></pre>
  
  <p>I want to add some code in the procedure to update the status column of those rows which are selected in cursor <code>OUT_CURSOR</code>.</p>
  
  <p>In short, I want to update rows fetched by the cursor <code>OUT_CURSOR</code>.</p>