Raise different exception depends on value input : Raise « PL SQL « Oracle PL / SQL






Raise different exception depends on value input

   
SQL>
SQL> CREATE OR REPLACE PROCEDURE RaiseIt(p_Exception IN NUMBER) AS
  2    e_MyException EXCEPTION;
  3  BEGIN
  4    IF p_Exception = 0 THEN
  5      NULL;
  6    ELSIF p_Exception < 0 THEN
  7      RAISE e_MyException;
  8    ELSIF p_Exception = 1001 THEN
  9      RAISE INVALID_CURSOR;
 10    ELSIF p_Exception = 1403 THEN
 11      RAISE NO_DATA_FOUND;
 12    ELSIF p_Exception = 6502 THEN
 13      RAISE VALUE_ERROR;
 14    ELSE
 15      RAISE_APPLICATION_ERROR(-20001, 'Exception ' || p_Exception);
 16    END IF;
 17  END RaiseIt;
 18  /

Procedure created.

SQL> show errors
No errors.
SQL>

   
    
  








Related examples in the same category

1.Raise your own exception
2.Raising an exception
3.Raising NO_DATA_FOUND Exception
4.RAISE_APPLICATION_ERROR
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