Oracle Application Express (MOSC)

MOSC Banner

Success and Error message for process in processing

We have a process that runs when a page is submitted and we have defined messages for 'Success Message' as 'Processing successful' as well as 'Error Message' as 'Processing Failed'.

A PL/SQL code is run in this process and pseudo code is something like below.

DECLARE
    V_NUMBER   VARCHAR2(250);
    V_REQ  NUMBER;
BEGIN
SELECT REQ_NO INTO V_REQ FROM ZZZ_TBL WHERE ROWNUM=1;
IF :P24_VALID_1 = 'Valid ' THEN    
    UPDATE XXX_TBL
        SET
            M_NUMBER =:P24_MRI,
    WHERE REQ =V_REQ  ;
        COMMIT;
ELSIF :P24_VALID_1 ='Invalid' and :P24_VALID_2 = 'Valid ' THEN
    UPDATE XXX_TBL
        SET
            M_NUMBER ='MRI-'||:P24_NEW_MRI,
    WHERE REQ =V_REQ;
        COMMIT;
END IF;
EXCEPTION
    WHEN OTHERS THEN
       RAISE_APPLICATION_ERROR(-20001,'Something went wrong. NIC Request could not be processed');
END;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center