Hello everyone .
I have this code. The problem is when I insert not correct EMP_NUM , there is an error which is no data found "ORA-01403: no data found" but I want display messge that says EMP_num Is not in the database.
CREATE OR REPLACE PROCEDURE new_drive(TMP_EM_NUM IN NUMBER ) AS
IF EMP_ID IS NULL THEN
Dbms_Output.put_line('that the employee was not found and do not perform any of the following steps');
Dbms_Output.put_line('that the employee was found');
END IF ;
You need to implement exception handling into the code using blow
WHEN NO_DATA_FOUND THEN
dbms_output.put_line ('A SELECT...INTO did not return any row.');