create or replace
PROCEDURE 프로시져이름 IS
BEGIN
어떠한 행동들...
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    DBMS_OUTPUT.put_line(SQLERRM);
    ROLLBACK;
  
  WHEN TOO_MANY_ROWS THEN
    DBMS_OUTPUT.put_line(SQLERRM);
    ROLLBACK;
  WHEN OTHERS THEN
    DBMS_OUTPUT.put_line(SQLERRM);
    ROLLBACK;
  
END;

+ Recent posts