EXCEPTION When no_data_found THEN
526410Nov 27 2006 — edited Nov 27 2006Hello all,
Can i quickly ask in the exception for no_data_found is it possible to have an ELSE after the THEN part of the exception.
For example;
SELECT CustID FROM Customers
Where CustID = 'CUS00011'
EXCEPTION
WHEN no_data_Found THEN
<Do This>
ELSE
<Do this instead>
Thanks in advance