What is an Exception ? What are types of Exception ?

Question Posted / guest

2 Answers
7375 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is an Exception ? What are types of Exception ?..

Answer / tulsi

Exception is the error handling part of PL/SQL block. The
types are Predefined and user_defined. Some of Predefined
execptions are.
CURSOR_ALREADY_OPEN
DUP_VAL_ON_INDEX
NO_DATA_FOUND
TOO_MANY_ROWS
INVALID_CURSOR
INVALID_NUMBER
LOGON_DENIED
NOT_LOGGED_ON
PROGRAM-ERROR
STORAGE_ERROR
TIMEOUT_ON_RESOURCE
VALUE_ERROR
ZERO_DIVIDE
OTHERS.

Is This Answer Correct ?

6 Yes

0 No

What is an Exception ? What are types of Exception ?..

Answer / chintu

Any ubnormal event in a program is called Exception.
In pl/ sql there are two types of exceptions they are
Userdefind Exception and predefined Exceptions.
Predefined exceptions are
CURSOR_ALREADY_OPEN
DUP_VAL_ON_INDEX
NO_DATA_FOUND
TOO_MANY_ROWS
INVALID_CURSOR
INVALID_NUMBER
LOGON_DENIED
NOT_LOGGED_ON
PROGRAM-ERROR
STORAGE_ERROR
TIMEOUT_ON_RESOURCE
VALUE_ERROR
ZERO_DIVIDE
OTHERS.
user defined exceptions are defined by raise_application_
error("error msg","error number") and
pragma_exception_init()

Is This Answer Correct ?

6 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers

What are all the different normalization?

0 Answers

What is a rank in sql?

0 Answers

How do I run a program in pl sql?

0 Answers

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers Tech Mahindra,

Explain what is dbms?

0 Answers

Why we use stored procedure instead of query?

0 Answers

difference between pl/sql table and normal pl/sql table

2 Answers

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers Polaris,

What is pl sql code?

0 Answers

How much does sqlite cost?

0 Answers

Is sqlite thread safe?

0 Answers

For more SQL PLSQL Interview Questions Click Here