Disable No_Data_Found Exception in Pl-SQL block
Posted on 2014-07-19
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,