But I had a lot of tables need to be updated (eg. summary1, summary2, summary3, detail1, detail2, detail3) and they are in separate function, should I open and close the connection in each function? if so, does the rollback function will work when it required? I need advice .. many thanks in advance ..

Regards
Winanjaya