title: Cursor in a Oracle pipe row function
body: <p>I have a pipelined function like this one:</p>
  
  <pre><code>pipe row(mytype('1','1','1'));
  pipe row(mytype('2','2','2'));
  pipe row(mytype('3','3','3'));
  pipe row(mytype('4','4','4'));
  return;
  </code></pre>
  
  <p>and I have another procedure that read this, using a cursor:</p>
  
  <pre><code>for c_cursor in(
    SELECT field1 FROM table(mytable)) 
  loop
    v_Var1:=c_cursor.field1;
    if((v_Var1 = '1')) then
      return;
    end if;
  end loop;
  </code></pre>
  
  <p>I need to know if Oracle will process the other rows (2,3 and 4) after the <code>return</code>, or it will stop the pipeline.</p>
  
  <p>Thanks.</p>