SQL & PL/SQL

Hello All,

When i am executing the procedure; it says the following warning message.

"Avoid use of RAISE_APPLICATION_ERROR built-in with a hard-coded -20,NNN error number or hard-coded message."


But my doubt is that; if we are using raise_application_error then definitely the range (-20,999 -> -20,000 ) should be given.

How can i resolve this warning message?


My procedure is in the below fashion:

PROCEDURE p_test IS
..
BEGIN
..
..
EXCEPTION
 WHEN OTHERS THEN

   ROLLBACK;

   -- Update Failure
	UPDATE ...

      SET ...
    WHERE ...


   raise_application_error(-20010

                          ,'Error While Processing: ' ||

                           p_emp_id || ',SQLCODE = ' || SQLCODE || ' : ' ||

                           SQLERRM);
END of procedure;