Hi Gurus,
I created a procedure my_log in a schema called A. I granted "Execute privilege" on my_log to a role called my_role.
Schema B has been granted wtih the role my_role.
When I am calling my_log procedure in an anonymous block logged as Schema B the block executes successfully.
But when i create a procedure my_proc and use A.my_log in schema B the procedure is not getting compiled and complains with the followign error.
PLS-00201: identifier 'A.my_log' must be declared.
Could you please let me know why is this happening. Code snippet attached.