10g Debug Anonymous Block

[panagakis]

I am trying to debug an anonymous block in 10g R2.

Basically when I start to step through the block, the debugger takes off and runs it to completion.

I used to be able to step through anonymous blocks in 9i.

Any ideas?

 

[Marco Kalter]

This is indeed no longer possible on Oracle10g.

You can create a simple "debug" stored procedure that can act as a placeholder for the anonymous PL/SQL that you want to debug, and create a standard test script to run it. This way you can make the process a little bit more efficient.