How to get output
from trigger?
I am writing a trigger and for debuging
I'd like to have an output.
I tried to just write into another table
and Select it, but as soon as
the trigger doesen't work properly, the
whole thing is roled back, so
that I can't see a thing.
Do you know how to make an output?
As far as I understad using the dbms_output
package has the same
problem.
Ans1:
No, it does not. However, you need a place
where the output can indeed be sent
to. So, you cannot test your trigger from
some user frontend, but need to test
your trigger in SQL*Plus, and in SQL*Plus
issue
set serveroutput on
Why not post your trigger code here?
Arjan.
Ans2:
Try DBMS_OUTPUT package.