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?