Debug Oracle stored procedure using Toad

I have the following situation: I have a java code launching a stored procedure. What I want is to launch the java code, and when arriving into the stored procedure, to start debuggin it using Toad.

Is thi开发者_C百科s possible?

I'm afraid it is not possible. The code will be executed in the session of the Java-Code, not in your Toad session.

EDIT:
Writing some trace in your application might be sufficient to track down the problems.

TOAD Debugger:
Looks like you need a special license, have a look at asktoad which lists the possible reasons if the menu is disabled.

If your license allows debugging, this article might be interesting to allow debugging with Oracle 10.

Oracle offer their own IDE, SQL Developer, which - usually for Oracle - is free. I know you probably don't want to install two IDEs on your desktop but I mention it because it supports debugging of PL/SQL procedures. Find out more.

It is possible to use DBMS_DEBUG by hand but I wouldn't advise it unless you have a lot of time and patience. Oracle intended it as an API for tool vendors rather than something for real people.

Bear in mind that however you initiate a debugging session you need an account with the DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE privileges.