Yearly Archives: 2014

The following piece of code, reads a list of problematic strings and tries to match them using a list of valid codes.In order to get the best match there is…

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