Sudees
asked on
Disable No_Data_Found Exception in Pl-SQL block
Hi,
In my Pl-SQL block there are 20 different SELECT queries extracting data from different tables. And the requirement is that all queries are independent to each other, means that if any SQL statement gives error the procedure should continue for next SELECT statement instead of STOPPING procedure at EXCEPTION level. I know that we can use BEGIN and END for each independent query to call its own EXCEPTION block. But is there any way to disable NO__DATA_FOUND exception for the said PL/SQL block so all the queries run continuously without using their separate BEGIN and END block.
Thanks and Regards,
In my Pl-SQL block there are 20 different SELECT queries extracting data from different tables. And the requirement is that all queries are independent to each other, means that if any SQL statement gives error the procedure should continue for next SELECT statement instead of STOPPING procedure at EXCEPTION level. I know that we can use BEGIN and END for each independent query to call its own EXCEPTION block. But is there any way to disable NO__DATA_FOUND exception for the said PL/SQL block so all the queries run continuously without using their separate BEGIN and END block.
Thanks and Regards,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I do not know of a way to disable exceptions for an entire block of code.
I feel you will either need to edit the code and do things the way they are supposed to be done or edit the selects as suggested above so they always return something.
I feel you will either need to edit the code and do things the way they are supposed to be done or edit the selects as suggested above so they always return something.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your suggestions..
ASKER