Updating an oracle database

fomba collins

Hi,
    I have got a problem updating my oracle database;When i run the code, there is no error detected but when I open the database, no changes have been made. Can someone hemp me please? Here is the code:

string connString = "DSN=cbc;UID=cbc;PWD=cbc";
                    OdbcConnection cnOracle = new OdbcConnection(connString);
                    cnOracle.Open();
                    OdbcCommand cmOracle = cnOracle.CreateCommand();
                    cmOracle.CommandText = "update mouvement set rapprocher = 1 where numerocompte = '"+code+"'";
                    MessageBox.Show(" comptes ont été rapprochés avec succès0000!!"); //to insure no errors during the insertion
                    cmOracle.ExecuteNonQuery();
                    MessageBox.Show(" comptes ont été rapprochés avec succès11111!!");//to insure no errors during the insertion
                    cnOracle.Close();

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Master Billa17y ago
Hi

1. add try catch to find correct query and copy that and paste in oracle query tool.

2. sometimes oracle may be lock the database commit. so click just refresh or commit icon in TOAD.

thank you
Mahesh Chand17y ago
Try using try..catch statement like this. Also check the value of CommandText in debugger and copy that string and run direct against your database see if Query syntax is correct.

string connString = "DSN=cbc;UID=cbc;PWD=cbc";
                    OdbcConnection cnOracle = new OdbcConnection(connString);
try
{
                    cnOracle.Open();
                    OdbcCommand cmOracle = cnOracle.CreateCommand();
                    cmOracle.CommandText = "update mouvement set rapprocher = 1 where numerocompte = '"+code+"'";
                    MessageBox.Show(" comptes ont été rapprochés avec succès0000!!"); //to insure no errors during the insertion
                    cmOracle.ExecuteNonQuery();
                    MessageBox.Show(" comptes ont été rapprochés avec succès11111!!");//to insure no errors during the insertion
                    cnOracle.Close();
}
catch(Exception exp)
{
   string str = exp.Message;
}