Hello, I am using DB 11.2.0.4.0 & APEX 20.2 & trying to store user's role ID in application item after authentication using below code but getting below error as mentioned in screenshot. Please help
select role_id into :GET_USER_ROLE
from acl_role
where role_id = (select role_id from acl_user where user_name = :APP_USER);
