1 comment

  1. Just add a BEGIN EXCEPTION and END block where you want to to be. For example…

    create or replace procedure…

    my_exception EXCEPTION;

    begin

    begin
    do some stuff…

    if condition then
    raise my_exception;
    endif;

    exception
    when my_exception THEN
    handle the exception
    end;

    more stuff…

    exception
    when others then

    end;

Leave a comment