Need inputs on how do I display Name in navigation bar instead of username. Tried the steps mentioned here: Display Full Name But receive an error on Application computations PL/SQL function body. declare v_app_user varchar2(30); begin v_app_user := V('P_APP_USER'); select fname into v_app_user from usertable where username = :APP_USER; return v_app_user; end; Can I someone please guide on what I seem to be following wrong?
Discy Latest Questions
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?