This content has been marked as final. Show 9 replies
I hope four users ('200','300','400','500') can select ALL option from the drop down list .
Your are telling its working for only two users , have you verified whether data is present for other two users who are not getting data in the report.
Your code looks ok , please check it again ..
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
Being a weekend I didn't had access to my script. It's a simple code. Since it's working for few alright I believe the code is fine. I just wanted to check if the basic logic in the script is a standard way to do it. My feeling is it's not able to capture the username of the two users. They exist in the user table fine. They have a username and Id like everyone else. Could their computer settings etc could cause an issue ?
1. Hope you are not getting a exception data_not_found which is also getting supressed somehow.
2. Try the following debugging as a last resort. Create table debug_log varchar2(100), and write a insert statement to put a record in the table with values nvl(user,nulluser) || nvl(id,nullid). Also put the commit statement.
3. REMEMBER to cleanup after the issue is resolved i.e drop debug_log and the remove the insert statement and the commit.
Thanks for evereyones help on this. I just created a test report that displays just the username, Id for whoever that runs the report. And the username and Ids dont get displayed on these peoples machine. It works fine for me and rest of my team.
Its just the clients machine(they just sit next to us and login to the application through citrix server just like us) where the username is not able to be captured.
Well, atelast I know now whats the problem.
I am looking to make an alternate report that is not based on usernames.