Hello,
I have a field on a form in APEX (on Autonomous DB 19c), which I want to make appear as Read Only to app users depending on authorisation level.
In the Page Item properties, under Read Only I have selected Expression for the Type, and PL/SQL for the Language.
Under PL/SQL Expression field, I have the following code which calls a package and a function:
bcs_team_auth.get_authorization_level(:APP_USER) = 1
This code has been tested ok in other pages where I've used it in WHERE clauses and such.
Screenshot 2021-02-18 at 07.47.26.png (17.55 KB)However, it does not seem to be working as expected. The field still appears as editable to an app user with level 1 authorisation.
What could I be doing wrong? Is it the way I'm calling the function?
Thank you in advance.