Hi Guys, i am trying to COMMIT before the SQR ends that is in between i am selecting some records on certain condition then i update and COMMIT but the program goes into infinite loop any help Thanks in advance khan __________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com