Blog

Here is a piece of code, which shows the structure of user defined exception:

declare
      exc_invalid_request_id     EXCEPTION;
...
      IF l_accepted_request > 0
      THEN
         RAISE exc_invalid_request;
      END IF;
...
   EXCEPTION
      WHEN exc_invalid_request
      THEN