ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)
There’s a strong chance that the privileges to select from table1 have been granted to a role, and the role has been granted to you. Privileges granted to a role are not available to PL/SQL written by a user, even if the user has been granted the role. You see this a lot for users … Read more