• Placement Papers
• /
• RDBMS
• /
• Logical Reasoning
• /
• Blood Relations

RDBMS Question Papers:

(#M40029880) RDBMS Logical Reasoning question RDBMS Keep an EYE

How are exceptions handled in PL/SQL? Give some of the internal exceptions' name?

Asked In RDBMS MAN (11 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (0)   (0) Submit Your Solution Blood Relations

Read Solution (1) :

swastika  (9 years ago)

The default exception will be handled using WHEN others THEN:

DECLARE

BEGIN

EXCEPTION

WHEN exception1 THEN
exception1-handling-statements
WHEN exception2 THEN
exception2-handling-statements
WHEN exception3 THEN
exception3-handling-statements
........
WHEN others THEN
exception3-handling-statements
END;

PL/SQL provides many pre-defined exceptions
ACCESS_INTO_NULL
CASE_NOT_FOUND
COLLECTION_IS_NULL
DUP_VAL_ON_INDEX
INVALID_CURSOR
INVALID_NUMBER
...& many more

Is this solution Helpfull? Yes (1) | No   

Please Login to Read Solution.