Search code examples
oracle-databaseplsqlsql-grant

Oracle grant execute to package doesn't work


I created package in schema CUST_DEV. In proc from my package I use proc from other package CUST_DS.CUST_CTL.proc().
When i recompile my package i received error: PLS-00201: CUST_DS.CUST_CTL.proc must be declared.
I have given privileges

grant execute on CUST_DS.CUST_CTL to CUST_DEV with grant option

I check in db_tab_priv new privileges for CUST_DEV on CUST_DS.CUST_CTRL.
But when i recompile my package i receive the same error. What i do wrong?

I have given privileges with grant option and without


Solution

  • I need to add schema name in calling proc: CUST_DS.CUST_CTL.proc(5) . Thank you, @PaulW