Quote Originally Posted by sloesch
Is there are RESUME NEXT statement in Orcale, where is if there is an exception, handle it, then Resume to the next statement instead of ending the proc? I could not find anything and this is my first time using Oracle.
you achieve this by nesting the BEGIN-END statements ...

Code:
create procedure ...
Is
Declare
   ...
Begin
   ...
   Begin
      ...
   Exception
      ...
   End
   ...
End;
/