Problems with the insert Qry used for explicit transaction m

Hi
please Can any one tell me how to use the insert Qry with commit , my transaction is Local_Transaction, but I am able to insert data in the data base without the commit , then my rollback is inutil in this case…