Hi All,
I am using c++ with soci to insert oid values to a table.
Table structure is as follows,
*CREATE* *TABLE* test_table (
key *varchar*(200) *NULL*,
value *oid* *NULL*
);
Value is a large xml file given as std::string.
What is the correct way to insert oid data using binding variables.
Used code snippet is given below which is not working.
std::string key = "test key";
std::string value = "test xml";
std::string sql = "insert into test_table(key,value) values (:KEY, :VALUE)
soci:use(key);
soci:use(value);
soci::statement st(session);
st.prepare(sql)
st.execute()
Thanks!
--
G.K.M.C Sajeewa