Tuesday, 16 February 2016

RAISE_APPLICATION_ERROR EXAMPLE

DECLARE
AGE NUMBER:=&AGE;
SATHYA EXCEPTION;
BEGIN
IF(AGE<10) THEN
RAISE SATHYA;
ELSE
DBMS_OUTPUT.PUT_LINE('ELIGIBLE TO JOIN IN THE SCHOOL');
END IF;
EXCEPTION
WHEN SATHYA THEN
RAISE_APPLICATION_ERROR(-20000,'AGE SHOULD NOT BE LESS THAN 10 YEARS');
END;

No comments:

Post a Comment

If you Like my blog Spread it and help friends for whom this blog is useful for their career.