Wednesday, December 9, 2009

Err: Control reached end of function without RETURN in PL/PGSQL

Error:
     Control reached end of function without RETURN
Reason: 
     Exception handler revokes all the things done in his immediate begin block and then exits. If only one root block is there means it ll take it as parent and stops the flow.
   
Solution:

     Put one begin end block for the immediate parent of the entire code including exception section will solve this problem.
 

No comments:

Post a Comment