Supporting Custom C++ Types 
by Stephen Hutton


// Listing One

#include <soci.h>
#include <iostream>
#include <string>

using namespace SOCI;
using std::string;

int main()
{
    try
    {
        Session sql("oracle", "service=gen1 user=scott " "password=tiger");
        sql << "create table Person(id number, name varchar2(50))";

        int id(100);
        string name("Bjarne");
        sql << "insert into Person values (:ID, :NAME)", use(id), use(name);

        int id2;
        string name2;
        sql << "select id, name from Person", into(id2), into(name2);
        assert(id2 == 100);
        assert(name2 == "Bjarne");

        std::cout << name2 << " has id "<< id2 << std::endl;

        sql << "drop table person";
    }
    catch(std::exception& e)
    {
        std::cout<<e.what()<<std::endl;
    }
}






1


