Dynamic Action Using PLSQL In Oracle Apex

Topic Introduction: Here we will show the example of Dynamic Action Using PLSQL In Oracle Apex.

Example#1

DECLARE

    v_link        NUMBER;

    v_existlink   NUMBER;

BEGIN

    BEGIN

        SELECT LINKID

          INTO v_existlink

          FROM GL_ACC_CODE

         WHERE USER_ACC_CODE = :P505_USER_ACC_CODE;

    EXCEPTION

        WHEN NO_DATA_FOUND THEN NULL;

        WHEN OTHERS THEN NULL;

    END;

    IF :P505_SUBSIDIARY_STATUS IS NOT NULL AND :P505_LINKID IS NULL

    THEN

        SELECT NVL (MAX (TO_NUMBER (LINKID)), 0) + 1 V

          INTO v_link

          FROM GL_ACC_CODE;

        :P505_LINKID := NVL (v_existlink, v_link);

    ELSE

        :P505_LINKID := NULL;

    END IF;

EXCEPTION

    WHEN NO_DATA_FOUND THEN NULL;

    WHEN OTHERS THEN NULL;

END;