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
Printable View
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
You can use autonomous transactions inside the trigger - store (and commit) the debugging information into database tables from within the trigger.
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
I said autonomous transactions. Check/search Oracle documentation (tahiti.oracle.com) by the therm "autonomous transaction".