RE: PGSQL insert data to a oid column using SOCI - Mailing list pgsql-novice

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!

--