One more thing,,if you want your proc/fun/pkg to be executed by another schema then you need to give an execute permission on the object to the particular user.

cheers