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: 142

Filed under:
|
|
|

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

Related posts about Oracle

Related posts about plsql