Hello,
We have around 300 forms used the keyword USER which return the oracle user.
earlier application design support this because we created db level user for each application user hence we got username thru USER keyword.
e.g. in forms. select profile_id into vprofile from custom_table where user_id = user;
Now in new design we have single db user with different application user (maintain at app level only)
so in each form we need to change the USER with some thing else may be a custom_function or global variable.
may be some of you face this situation and found any quick solution to manage this with any alternate :)
if yes please share