user11338524 wrote:why checking "ld" when should be checking "v_ld" variable?
I am developing a report where the user selects an option from a drop down list. Only four of the users can select ALL option from the list. In my plsql procedure I get their usernames first
Select user into v_user from dual;
Then get the Id of the user
Select Id into v_Id from user_table
Where upper(username) = upper(v_user);
If Id in ('200','300','400','500') then