[ACCEPTED]-PL/SQL function in Oracle cannot see DBMS_AQ-advanced-queuing
Does it work if you do...
instead of just 5
If so, you're missing a synonym.
If you're 4 now getting "PLS-00201: identifier 'SYS.DBMS_AQ" then 3 I'd double check your grants.
GRANT EXECUTE ON SYS.DBMS_AQ to <your-user>;
Also, just 2 to confirm, you've granted the execute privilege 1 directly to the user, and not via a role?
More Related questions