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
I need to add schema name in calling proc: CUST_DS.CUST_CTL.proc(5)
. Thank you, @PaulW