What is Exception in Oracle?

What is Exception in Oracle?

Predefined Oracle Exceptions are a part of the package and need not be explicitly written or declared. These exceptions are called if any oracle violation is overridden.

Example:
ORA-06530- ACCESS_INTO_NULL
ORA-06511- CURSOR_ALREADY_OPEN

User-Defined Exception is declared and written by the user himself depending on the need. They need to be raised explicitly using the RAISE command and declared in declaration section.

What is Exception in Oracle?

Errors occur during runtime processing due to either hardware or network failure or application logic errors are known as exception.

Types of Exceptions in Oracle :

- Predefined Oracle Exception
- User-Defined Exception
What are the predefined oracle exceptions?
Following is the predefined oracle exceptions No_data_found Too_many_rows Zero_divide.....
Explain user defined exceptions in oracle
A user can explicitly raise an exception by using the Raise command.....
How PL/SQL Exceptions Are Raised?
The PL/SQL exceptions can be raised in 4 ways. Either the user can raise them or they can be raised by the PL/SQL engine. They are as follows:....
Post your comment

Related Content

Follow us

▲