shilpi jain

 Profile Answers by shilpi jain 

• Dec 3rd, 2005

 

header

Bhoomika sharma

 Profile Answers by Bhoomika sharma Questions by Bhoomika sharma

• Dec 15th, 2008

 

I have a code here it actually goes:

1  FUNCTION Is_Value_In_List 
2     (value VARCHAR2, rg_name VARCHAR2, rg_column VARCHAR2) 
3     RETURN NUMBER 
4  IS 
5     Exit_Function EXCEPTION; 
6  BEGIN 
7     If bad-inputs THEN 
8        RAISE Exit_Function; 
9     END IF; 
10 
11    LOOP-through-record-group 
12       IF match-found 
13          RAISE Return_Value; 
14       END IF; 
15    END LOOP; 
16 
17    RAISE Exit_Function; 
18 
19 EXCEPTION 
20    WHEN Return_Value THEN 
21       RETURN row#; 
22 
23    WHEN Exit_Function THEN 
24       RETURN 0; 
25 END;

thus its clear the Return section is in the Exception section.