‎2006 Jul 06 9:11 PM
A program we have running in prod is calling
BG00_WARRANTY_LINK_UPDATE
The program has been running since yesteday and is not showing that there are any updates or inserts happening on the database.
The func mmod does actaul open SQL , UPDATE , INSERT. It is not called in update task... so when is the data committed ?
BAR
‎2006 Jul 06 9:16 PM
If u r calling the function in ur custom program u need to explicitly commit the data if the function does not return any errors.
If u r not explicitly commiting the data the program will commit the data when it finishes processing.
However it is advisable to commit after say every 50 records so that u do not lose data if the program errors out after processing some data.
-Kiran