Saturday, November 30, 2013

PL/SQL Custom Exception Handaling


DECLARE

  v_Return VARCHAR2(5000);

  custom_exception EXCEPTION;

BEGIN

  v_Return := 'A';
  
  
  IF v_Return = 'A' THEN
    RAISE custom_exception;
  END IF;

EXCEPTION
  WHEN custom_exception THEN
    DBMS_OUTPUT.PUT_LINE('error');
  
END;

No comments:

Post a Comment