Oracle Application Express 5: Developing Web Applications — Question 62

You have defined a form page on the ORDERS table and changed page item :P5_ORDER_TOTAL to type Hidden.
You also created a dynamic action to update the value of :P5_ORDER_TOTAL when any order items are added, updated, or deleted on the page.
However, when you submit the page, you get this error:
Session state protection violation: This may be caused by manual alteration of protected page item P5_ORDER_TOTAL. If you are unsure what caused this error, please contact the application administrator for assistance.
How should you update :P5_ORDER_TOTAL page item to prevent this error?

Answer options

• A. Set Value Protected to "No"
• B. Set Session State Protection to "Unrestricted"
• C. Change the item type to "Display Only"
• D. Set Store value encrypted in session state to "Yes"

Correct answer: D

Explanation

The correct answer is D because setting 'Store value encrypted in session state to Yes' ensures that the value of :P5_ORDER_TOTAL is protected against manual tampering, which is necessary for hidden items. The other options either do not provide adequate protection or change the item's behavior in a way that does not resolve the issue.