By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE PROCEDURE procedure_name
IS
BEGIN
BEGIN
DBMS_OUTPUT.PUT_LINE('Do something');
RAISE ZERO_DIVIDE;
DBMS_OUTPUT.PUT_LINE('This will be skipped');
EXCEPTION
WHEN OTHERS THEN
-- Do something to handle the execption (or, in this case, nothing)
NULL;
END;
DBMS_OUTPUT.PUT_LINE('Continue');
END;
/
BEGIN
DBMS_OUTPUT.PUT_LINE('Starting:');
procedure_name();
END;
/
1 rows affected
dbms_output:
Starting:
Do something
Continue
CREATE OR REPLACE PROCEDURE procedure_name
IS
BEGIN
BEGIN
DBMS_OUTPUT.PUT_LINE('Do something');
RAISE ZERO_DIVIDE;
DBMS_OUTPUT.PUT_LINE('This will be skipped');
EXCEPTION
WHEN NO_DATA_FOUND THEN
-- Do something to handle the execption (or, in this case, nothing)
NULL;
WHEN ZERO_DIVIDE THEN
-- Do something to handle the execption (or, in this case, nothing)
NULL;
END;
DBMS_OUTPUT.PUT_LINE('Continue');
END;
/
BEGIN
DBMS_OUTPUT.PUT_LINE('Starting:');
procedure_name();
END;
/
1 rows affected
dbms_output:
Starting:
Do something
Continue