PL/SQL Debugging

sabrina.vetter · Post by **sabrina.vetter** » Fri 27 Oct 2006 11:21

Hi,

I want to debug an Oracle Package which is called within a .Net Project ( written in C# ).

Example :

OracleCommand oracleCommand = new OracleCommand( "begin pack_sample.sample(); end", MyConnection, MyTrans );
rowAffectedByLastExecution = oracleCommand.ExecuteNonQuery();

I want to step into pack_sample when I make F11. I know it's possible via ODP / ODT on a database accessed with an Oracle Client, but when I try with a OraDirect connection, it doesn't work.

Duke · Post by **Duke** » Fri 27 Oct 2006 13:37

You can download OraDeveloper Tools 2.0 beta, which supports PL/SQL debugging. You can debug stored procedure from Database Explorer. But we do not support nested PL/SQL code debugging from C# code.

sabrina.vetter · Post by **sabrina.vetter** » Fri 27 Oct 2006 13:48

OK, thank you.