ORA-01400 EXAMPLE

WHEN WE DO NOT ENTER A CHARACTER VALUE IN ANY CONSTRAINT APLLIED COLUMN, THE ERROR CODE DISPLAYED LIKE ORA-01400 SOME MESSAGE. SO IT NOT UNDERSTAND TO END USER SO WE DISPLAYED THAT ERROR AS SOME UNDERSTANDABLE MESSAGE AS SHOWN IN BELOW PGM:

EXAMPLE:

DECLARE
NULL_FOUND EXCEPTION;
PRAGMA
EXCEPTION_INIT(NULL_FOUND,-01400);
BEGIN
INSERT INTO EMP(EMPNO,ENAME,SAL) VALUES(&EMPNO,'&ENAME',&SAL);
EXCEPTION
WHEN NULL_FOUND THEN
DBMS_OUTPUT.PUT_LINE('PLEASE ENTER ENAME VALUE');
END;