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