Debug Trigger?

[rkonda99]

Hi,
I use dbms_output.put_line when I create and run a function or procedure to see what are the values for variables at several locations in the program.
Is there anything like this to debug trigger?
Thanks,
Ramesh

[jmodic]

You can use autonomous transactions inside the trigger - store (and commit) the debugging information into database tables from within the trigger.

[rkonda99]

Hi Jurij,
Thanks for your feedback, but I can commit within the trigger. So, if the trigger fails, I will not have any info in the table.

ERROR at line 1:
ORA-04092: cannot COMMIT in a trigger
ORA-06512: at "QIS.T_WARR_BASED_ON_CARTID", line 61
ORA-04088: error during execution of trigger 'QIS.T_WARR_BASED_ON_CARTID'

Ramesh

[jmodic]

I said autonomous transactions. Check/search Oracle documentation (tahiti.oracle.com) by the therm "autonomous transaction".