Raising NO_DATA_FOUND Exception : Raise « PL SQL « Oracle PL / SQL






Raising NO_DATA_FOUND Exception

   

SQL>
SQL> DECLARE
  2    TYPE t_NumberTableType IS TABLE OF NUMBER
  3      INDEX BY BINARY_INTEGER;
  4    v_NumberTable t_NumberTableType;
  5    v_TempVar NUMBER;
  6  BEGIN
  7    v_TempVar := v_NumberTable(1);
  8  END;
  9  /
DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 7


SQL>

   
    
  








Related examples in the same category

1.Raise your own exception
2.Raising an exception
3.RAISE_APPLICATION_ERROR
4.Raise different exception depends on value input
5.Raise exceptions for wrong parameters
6.Print out an error message
7.Raises and manages a standard anonymous block PL/SQL program error.
8.This procedure demonstrates the use of RAISE_APPLICATION_ERROR.
9.Setting the message dynamically