Types of exceptions - Database executes a procedure locally or a remote location

Q.  How many types of exceptions can occur when the database executes a procedure locally or at a remote location?
- Published on 30 Jul 15

a. PL/SQL user-defined exceptions, which must be declared using the keyword EXCEPTION
b. PL/SQL predefined exceptions such as the NO_DATA_FOUND keyword
c. SQL errors such as ORA-00900 and ORA-02015
d. Application exceptions generated using the RAISE_APPLICATION_ERROR() Procedure
e. All mentioned above

ANSWER: All mentioned above

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 21 Sep 15
    - When the database executes a procedure locally or at a remote location, four types of exceptions can occur:

    1. PL/SQL user-defined exceptions, which must be declared using the keyword EXCEPTION
    2. PL/SQL predefined exceptions such as the NO_DATA_FOUND keyword
    3. SQL errors such as ORA-00900 and ORA-02015
    4. Application exceptions generated using the RAISE_APPLICATION_ERROR() procedure

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲