HowTo check whether Exception Block is available for the main PLSQL block or routine
        Posted  
        
            by 
                user1297211
            
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by user1297211
        
        
        
        Published on 2012-12-07T04:57:18Z
        Indexed on 
            2012/12/07
            5:03 UTC
        
        
        Read the original article
        Hit count: 216
        
I am trying to think of a validator that checks for Exception block available in PL/SQL block or any routine for the main body ( Highlighted in Bold).
Eg :
DECLARE
some data
      Procedure xyx IS
      BEGIN
      ....
      EXCEPTION
      ..
      END;  
BEGIN
some data
      BEGIN
      ....
      EXCEPTION
      ..
      END;  
**EXCEPTION**
some data
      BEGIN
      ....
      EXCEPTION
      ..
      END; 
END; 
This is a simple example there can be many other scenarios but my need id to find that Exception block is avaialble for the main block of PL/SQL code.
Please let me know if you have any suggestion. Thanks
© Stack Overflow or respective owner