Question: what is the difference between user-defined and predefined exceptions?
Answer: PL/SQL Raise Exception. All the predefined exceptions are raised implicitly whenever the error occurs. But the user-defined exceptions needs to be raised explicitly. ... If 'RAISE' is used separately in the program, then it will propagate the already raised exception to the parent block.