Test a stored procedure owned by another schema/user

[TomP]

I have execute rights on a stored procedure for another schema. Whenever I run the procedure nothing happens and I get no error, but if I run it as the schema owner, it works successfully. In PL/SQL Developer v12, as the schema owner, I am able to test and step through the code in debug mode, but I am not able to step into the code as the executing user. Is it possible to test and step through a procedure owned by another user, where you only have execute permissions?

 

[Marco Kalter]

Is this a standalone procedure or a procedure within a package? Can you also let me know your Oracle Server version?

 

[Ivan C.]

Make sure you grant EXECUTE and DEBUG privileges to the "executing" user too:

grant execute, debug on . to ;