Debugging after starting a Delphi app

[wayne]

I want to debug a trigger.

I seem to recall that you could start a debug session of a client application in Delphi. Set a breakpoint in the trigger in PL/SQL Developer. Then when the trigger is executed from an action in Delphi, the breakpoint in the trigger would allow continued debugging in PL/SQL Developer.

If this is possible, what steps are required? If not, then how can I achieve debugging/stepping through the code in the trigger?

 

[Marco van der Linden]

As far as I know it is not possible to debug a database trigger as it is treated as an anonymous PL/SQL block. If you want to debug the code you'll have to move the trigger code to a stored/packaged procedure and call that procedure from the trigger. You will have to set the breakpoint at the beginning of your stored/packaged procedure.

 

[Gustavo]

If you place your DML statement at a Test Window and press Step Into, you can debug the trigger. You must "Add debug information" before that.