Which statement is incorrect about User_Defined Exceptions?

Options
- Must be raised explicitly
- Raised automatically in response to an Oracle error
- Must be declared
- None of the above


CORRECT ANSWER : Raised automatically in response to an Oracle error

Discussion Board
user_defined exception

The user-defined exceptions must be declared and must be raised explicitly by RAISE statements. Exceptions can be declared only in the declarative part of a PL/SQL block, subprogram, or package. You declare an exception by introducing its name, followed by the keyword EXCEPTION. You cannot declare an exception twice in the same block. You can, however, declare the same exception in two different blocks.
Exceptions declared in a block are considered local to that block and global to all its sub-blocks. Because a block can reference only local or global exceptions, enclosing blocks cannot reference exceptions declared in a sub-block.

Prajakta Pandit 02-28-2017 02:09 AM

Write your comments

 
   
 
 

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


Advertisement