https://www.udemy.com/course/plsql-by-example/learn/lecture/3169168#overview

Exceptions

Exception은 두 종류로 나뉜다.

• System-defined exceptions

  • no_data_found

  • too_many_rows

• User-defined exceptions

EXCEPTION
    WHEN NO_DATA_FOUND THEN
        DBMS_OUTPUT.PUT_LINE('머시기');
    WHEN OTHERS THEN
        DBMS_OUTPUT.PUT_LINE('기타오류');

User Defined Exceptions

CREATE OR REPLACE PROCEDURE GET_CUSTOMER
(
c_id IN NUMBER
)
AS
DECLARE
    ex_customer_id EXCEPTION;
BEGIN
    IF c_id <= 0 THEN
        RAISE ex_customer_id;
EXCEPTION
    WHEN ex_customer_id THEN
        DBMS_OUTPUT.PUT_LINE('ID는 0보다 커야 합니다');