I support a linux tool that used SOCI 3.0.0 to communicate with an Oracle
database. I recently had to update the version of SOCI used to 3.1.0 and
now I am unable to get data back from Oracle. This is the code I am using:
std::ostringstream str;
str << "service=" << mDbServer << " user=" << mDbUser << "
password=" << mDbPassword;
Log::getInstance().info("Connecting to database " + mDbServer +
" as user " + mDbUser);
// Connect to the datbase.
mDbSession = shared_ptr<session>(new
soci::session(soci::oracle, str.str()));
// Run a quick test query to verify the connection.
(*mDbSession) << "update filters set name = 'kevin' where name
= 'hamster'";
// Run a second test query to verify I can get data from the
connection.
int test;
(*mDbSession) << "select 1 from dual", into(test);
Everything goes ok, until the last line when I get an exception with the
error message "ORA-24338: statement handle not executed". This works fine
with SOCI 3.0.0 but as soon as I upgrade to SOCI 3.1.0 it fails :(
I hope someone can help!
Kevin Rose
DreamWorks Animation
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
