Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Debugging accross schemas, how?

540444Nov 5 2009 — edited Nov 7 2009
Has 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,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 5 2009
Added on Nov 5 2009
8 comments
753 views