#include "stdafx.h"
#include <iostream>
using namespace std;
#include <stdio.h>
//#define OTL_ORA10G
#define OTL_ORA9I // Compile OTL 4.0/OCI9i
#define OTL_ORA_UTF8 // Enable UTF8 OTL for OCI9i
#include <otlv4.h> // include the OTL 4.0 header file
#pragma comment(lib, "oci.lib")
otl_connect db; // connect object
#define CONNECTSTRING "test/12345@192.168.1.202"
char strSelectSql[100] = { "select f1,f2,f3 from test_tab"};
char strDeleteSql[100] = { "delete from test_tab where f1 = '4' "};
char strUpdate[150] = { "update test_tab set f2 = 'Olympiad in china' , f3 = to_date('2008-08-08 08:08:08','yyyy-mm-dd hh24:mi:ss') where f1 = 5 "};
void insert()
{