How can I debug an oracle stored procedure from a .net web app?

Question

I have a .net web application that makes heavy use of oracle stored procedures.

One of these is problematic - some times it works, some times it doesn't.

Is there any way to either attach a debugger to oracle when the sp is called, or step into it directly from Visual Studio?

What other debugging techniques are there for a .net/Oracle web app?

Answer 1

You can step into pl/sql debugging code from visual studio. (I do it all the time)

You will need to use the Oracle Developer Tools (http://www.oracle.com/technology/tech/windows/odpnet/index.html) from Oracle but here is their walk-through that should get you up and running.

http://www.oracle.com/technology/oramag/oracle/06-sep/o56odp.html

it takes a little set up, but once it is working you can debug directly from .net into Oracle code.

Here is Christian Shay's walk-through (he's the Product Manager in the .NET and Windows group at Oracle) http://cshay.blogspot.com/2006/07/plsql-debugger-in-visual-studio.html