title: plsql/cursors handle exception and return back to the execution flow
body: <p>I am trying to execute a cursor and want it to complete the loop even if there is some exception.</p>
  <p>What I trying to do is &quot;catch&quot; all the exception and probably log something or do nothing  and then return back to the flow . Here is how the code looks like:</p>
  <pre><code> FOR line IN my_cursor
   LOOP
   begin
          
      if&lt;condition&gt; then
        GOTO pass; 
      else     
       &lt;&lt;do_something&gt;&gt;
       exception
         when others then
          sys.dbms_output.put_line('say something');       
      end if;  
  
      &lt;&lt;pass&gt;&gt; null;
   end
   END LOOP;
  </code></pre>
  <p>The script doesn't compile.</p>
  <p>There is probably some syntax error with the exception, but I am also not aware of semantics very well. Like I am not sure if you can return back to execution flow after handling an exception.</p>
  <p>p.s: The DB is 10g and there is not CONTINUE in it. Hence using GOTO.</p>