Anonymous

What Is Exception Handling In Oracle?

2

2 Answers

soumya Moharana Profile
soumya Moharana answered
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
thanked the writer.
Utsav Mukherjee
Utsav Mukherjee commented
your's is okay but try to elaborate, other wise to a beginner, it will become impossible to understand.....
Utsav Mukherjee Profile
Utsav Mukherjee answered
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.

Answer Question

Anonymous