Hello experts, I am new in oracle using oracle sql developer in windows7.I am little bit confuse in that I am using commit in a trigger as given : create or replace trigger comt after insert on tbl_city declare pragma autonomous_transaction; begin commit; dbms_output.put_line('Value is committed'); end; Now when I perform an insert in tbl_city---->trigger fires properly and gives output stream. But If I perform rollback now --->there are the data rollbacked in table. why?I think after commit(which is in trigger associated at insert to table)there should no any rollback in table. Please give solution to my confusion . Thank You regards aaditya.