Trigger Question

[scm7jaj]

Hi Guys,

Just a quick question, I have created a trigger and it has the following portion:

EXCEPTION
WHEN OTHERS THEN
RAISE_APPLICATION_ERROR( -20001, 'During Trigger Execution' || SQLERRM );
end;


What I would like to know is there any way that a message can be generated if the trigger executes correctly.

[TomazZ]

If trigger executes correctly, you will get
X rows inserted/updated/deleted
after the triggering statement
If this is not enough put dbms_output.put_line('This is a super successful trigger') before exception.