[ACCEPTED]-PL/SQL function in Oracle cannot see DBMS_AQ-advanced-queuing
Accepted answer
Does it work if you do...
SYS.DBMS_AQ
instead of just 5
DBMS_AQ
If so, you're missing a synonym.
EDIT:
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?
Source:
stackoverflow.com
More Related questions
Cookie Warning
We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.