Submitted Questions

  • Call a Procedure in Trigger

    How to call a Procedure in Trigger and if any exception occurs in trigger then How do we rollback it?

    Ayaz Uddin

    • Nov 20th, 2014

    Create or replace trigger trg
    after insert on emp
    for each row
    begin
    myproc(:new.empno, :new.ename);
    end;