Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

getting Session state protection violation error for a hidden item that is being set with computation before header - Oracle APEX

Tags:

oracle-apex

I am trying to set the label of an item dynamically using the value of an other hidden item in the same page.

I created a computation for the hidden item in the page and set the value of the item as the dynamic label - &P613_EMPLOYEE_TYPE_LABEL.

But I am getting this error

Session state protection violation: This may be caused by manual alteration of protected page item P613_EMPLOYEE_TYPE_LABEL.   

Technical Info (only visible for developers)

is_internal_error: true
apex_error_code: APEX.SESSION_STATE.ITEM_VALUE_PROTECTION
component.type: APEX_APPLICATION_PAGES
component.id: 149000000613
component.name: DETAILS OF EMPLOYEE
error_backtrace:
----- PL/SQL Call Stack -----
object      line  object
handle    number  name
0x263d96750       935  package body APEX_050100.WWV_FLOW_ERROR
0x263d96750      1003  package body APEX_050100.WWV_FLOW_ERROR
0x263d96750      1395  package body APEX_050100.WWV_FLOW_ERROR
0x26ac006a8      3116  package body APEX_050100.WWV_FLOW
0x26ac006a8      5533  package body APEX_050100.WWV_FLOW
0x265a48af8         2  anonymous block

But I have set the session state protection fo the item to 'unrestricted'

page settings page settings

computation
computation

component settings
component settings

like image 585
Anuswadh Avatar asked Jan 25 '17 07:01

Anuswadh


2 Answers

For your hidden item P613_EMPLOYEE_TYPE_LABEL set the Value Protected attribute to NO.enter image description here

When Value Protected of an hidden item is set to YES a checksum is generated when your page is loaded. When you submit the page with a different value the checksum is not valid anymore and you get the error.

like image 169
Cristian_I Avatar answered Nov 01 '22 23:11

Cristian_I


"Value protected" only shows for hidden items. This error shows also when you update a visible item that is read only. At least in rel 19.2. See this question also: Can't disable session state protection on Oracle APEX 18.1.0.00.45 for Dynamic Actions updating Page Items

like image 31
Tore H Avatar answered Nov 01 '22 23:11

Tore H