RE: Can i write commit in trigger? not then? why i cant write commit in trigger?
As trigger is implicitly fired u can not commit.Here I m giving one example. Let u wrote a trigger for inserting 100 records And after that U wrote commit When the particular event occures the trigger will fired At the time of record inserting let the power is gone away so as u gave commit statement the no. of records should have inserted before power cut but rest of records will not inserted. I think r8 now U could understand the disadvantages of writing commit or rollback in the trigger body.
