Exception Handling Example

Submitted by:Jhon Brain

Date added:01 October, 2011

Category:PL SQL

An example of Exception Handling in PL SQL

Tags: exception handling

Code Snippet:

BEGIN
FOR emp_rec IN c_empl
LOOP
...
END LOOP;
RETURN v_exist;
EXCEPTIONS
WHEN NO_DATA_FOUND THEN
RETURN FALSE;
WHEN VALUE_ERROR THEN
RETURN FALSE;
WHEN OTHERS
RETURN FALSE;
END;
 
 

Comments