Tuesday, January 18, 2011

Oracle - RAISE_APPLICATION_ERROR



DECLARE

    EMPID NUMBER(3) := 25;
BEGIN

    DELETE FROM TEMPEMP WHERE  ID = EMPID;
   
    IF SQL%NOTFOUND THEN
        RAISE_APPLICATION_ERROR(-20202,'INVLID EMPLOYEE');
    END IF;   

END;

No comments:

Post a Comment