locked
Stepping into Oracle stored procedures RRS feed

  • Question

  • User-1934530859 posted

    I have an ASP.NET application that uses an Oracle backend. I want to be able to step into the Oracle packages and stored procedures during debugging.

    Is this possible and if so what toolset would be needed? Thanks.

    Saturday, February 26, 2011 7:08 PM

Answers

All replies

  • User269602965 posted

    It is such a pain the *** to setup PL/SQL for debugging from within Oracle,

    I have moved all my old PL/SQL into VB.NET and CS.NET with ODP.NET.

    I get greater flexibility and speed in doing business processes on variables woth .NET, and the .NET SQL statements run faster than PL/SQL.

    Good bye PL/SQL.  Life is so much better in Code Behind Form/Page without PL/SQL.

    Saturday, February 26, 2011 9:28 PM
  • User-2098386135 posted

    I've found that PL/SQL Developer from AllAroundAutomations has great PL/SQL debugging capabilities. I've never tied it into an application debug though. But as long as you know the parameter values you want to test, it's a good tool to have.

    Monday, February 28, 2011 11:57 AM
  • User269602965 posted

    Good to know the SQL Developer removes some of the pain setting up debugging for PL/SQL, but of course does not solve the forum problem.

    Monday, February 28, 2011 9:43 PM
  • User-1934530859 posted

    Ho wdo you debug a proc using PL\SQL developer? I downloaded the trial and all of the debug options are greyed out.

    Thursday, March 3, 2011 8:20 AM
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, March 3, 2011 8:37 AM
  • User269602965 posted

    http://forums.oracle.com/forums/forum.jspa?forumID=260

    SQL Developer Forum on Oracle Technical Network

    Thursday, March 3, 2011 8:39 AM