Debugging accross schemas, how?
540444Nov 5 2009 — edited Nov 7 2009Has anyone had success debugging PL/SQL across schemas? Since we do not have the Apps password in our Test environment we cannot run the debugger against it. We tried to grant access to another user with no success. We tried DEBUG CONNECT SESSION, DEBUG ANY PROCEDURE, GRANT EXECUTE... nothing worked. We tried with SQL Navigator, TOAD, and SQL Developer/Jdeveloper.
We know we can use dbms_output.put_line etc. but that requires code migration to the environment we are debugging and a bit of a time delay/hassle to do so. The debugger works great but how can we use it in a Test environment without the Apps password? Any suggestions? How does everyone else debug in a Test like environment?
Thanks,