I am not able to execute this proc. Getting an error 'table or view does not exist'. If I execute in Schema1, there is no error.
create or replace procedure schema2.procedure2 begin -- logic -- Schema1.Procedure1(input); -- end;
CP wrote:Why do you believe that it is the call to schema1.procedure1 that is failing? If you are actually getting an ORA-00942 error, rather than a more generic `PROCEDURE1` is not a procedure or is undefined, what makes you believe that the problem is the call to schema1.procedure1?
Tried giving access to the User directly as well. Schema2 has Debug and Execute privileges on schema1.procedure1. Still same Issue.
CP wrote:OK. So the problem has nothing to do with your inability to call procedure1 from procedure2.
View program sources of error stack?