top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Oracle: Any three PL/SQL Exceptions?

+2 votes
345 views
Oracle: Any three PL/SQL Exceptions?
posted Mar 17, 2015 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+2 votes
 
Best answer

An error condition during a program execution is called an exception in PL/SQL. PL/SQL supports programmers to catch such conditions using EXCEPTION block in the program and an appropriate action is taken against the error condition.
There are three types of exceptions:

a) Named System Exceptions 

b) Unnamed System Exceptions 

c) User-defined Exceptions
answer Mar 18, 2015 by Shivaranjini
0 votes

Too_many_rows, No_Data_Found, Value_Error, Zero_Error, Others

answer Mar 18, 2015 by Arun Gowda
...