2 Replies Latest reply on Jul 24, 2012 5:37 PM by 951212

    Stateful session in OCCI


      I am using Oracle Database 11g Express Edition Release - 64bit. I am using the OCCI interface in my application.
      I am creating a connection using oracleEnv->createConnection (user, passwd, db);
      With that connectio object, i am updating the data in one of the tables in my database using the preparestatement like below.

      oracle::occi::Statement *stmt = oracleConn->createStatement (statement, tag);
      int count = statement->executeUpdate ();

      WITHOUT commiting the update, i use the same connection object to query the db (using statement->execute() method)
      for cross checking the values. But the output of the query still gives me the old value not the updated value.

      Please help.