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

Question

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

One of them is problematic - sometimes it works, sometimes it is not.

Is there a way to connect the debugger to oracle when calling sp or run it directly from Visual Studio?

What other debugging methods are there for a .net / Oracle web application?

Answer 1

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

Oracle Developer Tools (http://www.oracle.com/technology/tech/windows/odpnet/index.html), , .

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

, , .net Oracle.

( .NET Windows Oracle) http://cshay.blogspot.com/2006/07/plsql-debugger-in-visual-studio.html

Answer 2

Pl\Sql Developer. , .:)

, Oracle SP .net(, , ).

, , , , ( , ).

Answer 3

pl/sql visual studio . , , PL/SQL Developer. , DBMS_DEBUG, , PL/SQL Developer , :