ORA-04042: procedure, function, package, or package body does not exist
Hi,
I have created a procudure and some funtions in it. I can use them properly but now i want to use it from another schema. When i grant the execute on function it gives error.
ORA-04042: procedure, function, package, or package body does not exist
I have executed followin command to grant execute privilige.
grant execute on xxzg_leave_calculation.XXZG_GET_LEAVE_ELIGIBILITY to ABC;
Please Help me.
Regards,
Obaidullah Syed