Page 1 of 1

PL/SQL Debugging

Posted: Fri 27 Oct 2006 11:21
by sabrina.vetter
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.

Posted: Fri 27 Oct 2006 13:37
by Duke
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.

Posted: Fri 27 Oct 2006 13:48
by sabrina.vetter
OK, thank you.