how to debug triggers?

[sunyardxlt]

hello, I write a trigger, but I can not debug it.
How can I do to debug it?

 

[patch]

If you put the code the trigger executes into a package or stored procedure then you can debug that code.

Hope this helps,
Patrick

 

[orca777]

Hi,
as i remember it worked with the test-window:
if you want to test an INSERT-Trigger, write the INSERT-SQL
in the anonymous PL/SQL Block of the Test-window, set the breakpoint in the INSERT-Trigger and run the Test-window in DEBUG-Mode.

The execution stops at break-point;
carl

 

[Marco Kalter]

You don't even need an anonymous PL/SQL Block. Just place the SQL Insert/Delete/Update statement in the Test Window, start the debugger, step into the SQL statement, and you will end up in the first executable line of the trigger.

 

[sunyardxlt]

thanks all