I would like to know anybody knew a solution for my problem given
below:
I have an mfc application which accesses an oracle[8.1x] database.
Now if make a lot of modifications on a huge set of data which is
represented as structures in mfc, then try to save the modification
which result in a big loop trying to run like the following:
try{
for(....)
{
strSQL="Update....."; //form the update query for one data in the
struct
db.ExecuteSQL();
}
} execption_handler()
if(not something wrong)
db.CommitTrans();
else
db.RollbackTrans();
Now in this code, for each update query in a loop, oracle opens a
cursor and doesn't close until i close the db connection. even if i
add a piece of code which closes and opens db connection in the loop
for every 100 updates [ofcourse after commiting], i lose the
flexibility of rolling back on an error.
