This block illustrates the behavior of a predefined exception : Predefined Exceptions « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Predefined Exceptions

This block illustrates the behavior of a predefined exception

    

SQL> BEGIN
  2    RAISE NO_DATA_FOUND;
  3  END;
  4  /
BEGIN
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 2


SQL>
SQL>








Related examples in the same category

1.Predefined exceptions: WHEN ZERO_DIVIDE
2.If an ordering is applied, it occurs after the WHERE has been executed
3.NO_DATA_FOUND Exception
4.This script demonstrates user defined exceptions
5.This script demonstrates the scope of exceptions.