Hi all,
I've got table table1 with trigger trigger1
CREATE or REPLACE TRIGGER trigger1
AFTER UPDATE
ON table1
BEGIN
procedure1;
EXCEPTION
WHEN OTHERS THEN
return;
END;
It works fine, I mean it starts procedure procedure1 after performing update on table table1.
The question is, is it normal behavior that my update script waits untill procedure procedure1 runs? I don't have experience with triggers yet. I'm looking for some way to return control just after procedure procedure1 starts, I don't want to wait untill it ends its work.
Is it possible at all?
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production