Q:
Explain some of the commonly used Predefined PL/SQL Exceptions.
Answer
1)Divide by zero – This is raised when any number is attempted to divide by zero.
2)TOO MANY ROWS - A SELECT INTO statement returns more than one row.
3)CASE_NOT_FOUND - No choice in the WHEN clause of a case statement is selected.
4)LOGIN_DENIED - An attempt to login with an invalid username or password.
5)PROGRAM_ERROR - An internal PL/SQL problem.
View answer
Workspace
Report Error
Discuss