HowTo check whether Exception Block is available for the main PLSQL block or routine
- by user1297211
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
