KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am trying to execute a cursor and want it to complete the loop even if there is some exception. What I trying to do is "catch" all the exception and probably log something or do nothing and then return back to the flow . Here is how the code looks like: FOR line IN my_cursor LOOP begin if<condition> then GOTO pass; else <<do_something>> exception when others then sys.dbms_output.put_line('say something'); end if; <<pass>> null; end END LOOP; The script doesn't compile. 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.s: The DB is 10g and there is not CONTINUE in it. Hence using GOTO.
Tags (comma-separated)
Save Edits
Cancel