What Is Exception Handling In Oracle?

Question

What Is Exception Handling In Oracle?

2 Answers

Answer Question

Answer 1

While we are writing any PL/SQL block there may be chances that datatype discrepancies or Constraint type problem or some kind of unusual error. At that time after every SQL statement we define a user defined Exception handler or system defined handler to track the error occurred line. This is called Exception handling in Oracle

Answer 2

An exception is an abnormal situation which becomes an obstacle in the normal flow of the program.
When you are writing a PL/SQL block which is an procedural extension of SQL, there comes the following sequence of blocks:
declare
< variables,cursors etc>
begin
< body of the PL/SQL block>
exception

end

in the exception block we have to define a user defined Exception handler or system defined handler to track the error occurred line. This is called Exception handling in Oracle which helps to handle datatype discrepancies or Constraint type problems or any other kinds of abnormal situations.