Scenario 1) If you issue COMMIT, data will be posted to ables and cursor will be clsoed automatically ( If you dont use WITH HOLD option in the cursor )
Scenarios 2) Even you dont use COMMIT and/or CLOSE CURSOR command. At the end of the program all changes will refelected into tables.
But advise is, always use COMMIT & CLOSE CURSOR, wherever it is required.
I guess,these things are part of program standards in every shop. _________________ Natarajan
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum