APEX_ERROR Show by PLSQL

 


/************Insert Data into Table*************/

declare

    v_has_error BOOLEAN := FALSE;

begin

    FOR R1 IN (

            SELECT 
              COL.c001 AS SOLD_TO_CUSTOMER_ID,
              COL.c002 AS GROUP_CODE,
              COL.c003 AS SALESREP_ID,
              COL.c004 AS SHIP_TO_ADDRESS
              |
              |
              |
FROM TABLE_NAME

)

LOOP

      --=== Not Null Validation ===

        IF      R1.SOLD_TO_CUSTOMER_ID IS NULL 
           OR  R1.GROUP_CODE IS NULL
           OR  R1.SALESREP_ID IS NULL
           OR  R1.ITEM_ID IS NULL

        THEN

            APEX_ERROR.ADD_ERROR(

                p_message => 'Please enter a value (Customer, Group, Salesrep, Item ID) for the item.',

                p_display_location => APEX_ERROR.C_INLINE_IN_NOTIFICATION

            );

            v_has_error := TRUE;

        END IF;


        -- skip insert if error found

        IF v_has_error THEN

            RETURN; 

        END IF;

INSERT INTO TABLE_NAME ( COLUMN_1, COLUMN_2,,,,,)

VALUERS ( R1.SOLD_TO_CUSTOMER_ID, R1.GROUP_CODE ...)


   END LOOP;

    COMMIT;


EXCEPTION

         WHEN OTHERS THEN

              DBMS_OUTPUT.PUT_LINE('Error: '||SQLERRM);

END;


Post a Comment

Previous Post Next Post