2 Replies Latest reply on Feb 12, 2019 11:23 AM by indy2005

    Error setting Request Value by PL/SQL

    indy2005

      Hi,

       

      I need to reset the request value on a submit, as it seems to get lost on a save of the form.  I am passing it in via a link setting on a previous page, and the request value drives the visibility of various parts of the form.

       

      As I am saving in the form, the request value is obviously being reset and then sections of the page dissapear.

       

      I am therefore trying to set the request value manually during the page process, but am getting an error.

       

       

      When running this PL/SQL process.

       

      UPDATE DIM_LABEL_REG_LICENSE_FEEDBACK

      SET

       

          TR_FOLLOW_UP             = :P6_TR_FOLLOW_UP,

          TR_COMMENTS              = :P6_TR_COMMENTS,   

          TR_LAST_SAVED_BY         = :APP_USER,

          TR_LAST_SAVED_DATE       = sysdate,

       

          TR_XEVMPD_IMPACT         = :P6_TR_XEVMPD_IMPACT,

          TR_XEVMPD_COMMENT        = :P6_TR_XEVMPD_COMMENT

         

        

         WHERE CUSTOM_UNIQUE_ID    = :P6_CUSTOM_UNIQUE_ID;

        

      APEX_UTIL.set_session_state(p_name => 'REQUEST', p_value => 'SaveTriage');

        • 1. Re: Error setting Request Value by PL/SQL
          fac586

          indy2005 wrote:

           

          Hi,

           

          I need to reset the request value on a submit, as it seems to get lost on a save of the form. I am passing it in via a link setting on a previous page, and the request value drives the visibility of various parts of the form.

           

          As I am saving in the form, the request value is obviously being reset and then sections of the page dissapear.

           

          I am therefore trying to set the request value manually during the page process, but am getting an error.

           

           

          When running this PL/SQL process.

           

          UPDATE DIM_LABEL_REG_LICENSE_FEEDBACK

          SET

           

          TR_FOLLOW_UP = :P6_TR_FOLLOW_UP,

          TR_COMMENTS = :P6_TR_COMMENTS,

          TR_LAST_SAVED_BY = :APP_USER,

          TR_LAST_SAVED_DATE = sysdate,

           

          TR_XEVMPD_IMPACT = :P6_TR_XEVMPD_IMPACT,

          TR_XEVMPD_COMMENT = :P6_TR_XEVMPD_COMMENT

           

           

          WHERE CUSTOM_UNIQUE_ID = :P6_CUSTOM_UNIQUE_ID;

           

          APEX_UTIL.set_session_state(p_name => 'REQUEST', p_value => 'SaveTriage');

          It is not possible to set the REQUEST value programmatically. This can only be done in a button submit action, link, or branch.

           

          For the use case described it looks like you will need to capture the REQUEST value on entry into a hidden page item, and use this to set the REQUEST when branching back to the page after submission.

          1 person found this helpful
          • 2. Re: Error setting Request Value by PL/SQL
            indy2005

            Thanks, as always.