Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1 (col1 int);
CREATE PROCEDURE raise_error AS
BEGIN
  INSERT INTO table1 VALUES (1/0);
END;
/
INSERT INTO table1 VALUES (1);
1 rows affected

CALL raise_error();
ORA-01476: divisor is equal to zero
ORA-06512: at "FIDDLE_MSPOACXTFNLNVWICMHQH.RAISE_ERROR", line 3

COMMIT;
SELECT * FROM table1;


COL1


1