Statement *stmt=conn->createStatement();
stmt->execute("savepoint XXX");
...
stmt->execute("rollback to XXX");

create table spcheck(state number(1)); -- from SQL prompt

// In OCCI code :

	  stmt = conn->createStatement("INSERT INTO SPCHECK VALUES(1)");
		stmt->execute();

		stmt1=conn->createStatement();
		stmt1->execute("SAVEPOINT SPONE");

	  stmt2 = conn->createStatement("INSERT INTO SPCHECK VALUES(2)");
		stmt->execute();

    stmt1->execute("ROLLBACK TO SPONE");		
    conn->commit();