This discussion is archived
2 Replies Latest reply: Jul 24, 2012 10:37 AM by 951212 RSS

Stateful session in OCCI

951212 Newbie
Currently Being Moderated
Hi,

I am using Oracle Database 11g Express Edition Release 11.2.0.2.0 - 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.

regards,
Jaya

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points