Hello Sir, to retrieve the status of a form from the logged in user, I did the following: - created application item 'STATE_OF_FORM'. - created application process to set the value into the application item this takes the status from a table and should set it in the application_item. Unfortunately it doesn't work as hoped, I think the error is in the syntax: --this is the code to set stored table status into the status application item declare v_state varchar2(50); begin select fp.STATE into v_state FROM PROCESSSTEPS_FORM fp left outer join USERS u on fp.UUID=u.UUID where u.username=:APP_USER; Apex_Util.Set_Session_State('STATE_OF_FORM', v_state); --exception handling needed otherwise the error 'ORA-01403: no data found' will exception be raised when no_data_found then NULL; end; What do I do wrong?
Discy Latest Questions
I have an item A whose value is chosen from a Select list. Depending on the chosen value, a DA is activated and in its true option it updates an item B, with the option Set value, that does it well and shows it on the screen. The problem is that item B has the Value required parameter set to true and therefore it shows me a validation error even though item B shows the value on the screen. How can I solve that ?