Who Can Create An Exception

The CREATE EXCEPTION statement can be executed by:

The user executing the CREATE EXCEPTION statement becomes the owner of the exception.

Creating an exception named E_LARGE_VALUE

CREATE EXCEPTION E_LARGE_VALUE
  'The value is out of range';

Creating a parameterized exception E_INVALID_VALUE

CREATE EXCEPTION E_INVALID_VALUE
  'Invalid value @1 for field @2';