Hello everyone,
MY APEX VERSION NUMBER : 22.1.0
I use a PL/SQL Function Body to create an SQL request according to the role of the user.
However, as I added a role, the size of the body increased, and I get this error : Value too long by 2091 characters!
Indeed, there are 35521 characters in this PL/SQL body.
I thought about something to avoid this problem : create a function which to the big part of the job (generate the SQL request according to the user roles), and just call it from APEX.
Could you confirm me if this method is correct ? It seems, or if there is another method, easier method.
Thank you for you experience !