hemny - 2015-05-18

script for create table:
create table test_tab(f1 int, f2 VARCHAR(200), f3 VARCHAR(200), f4 VARCHAR(200) )

base unixODBC and define:

define OTL_STL

define OTL_ORA12C

define OTL_ORA_UTF8

define OTL_ODBC_MULTI_MODE

define OTL_ORA_TIMESTAMP

define OTL_ORA_LEGACY_NUMERIC_TYPES

ifndef OTL_ANSI_CPP

define OTL_ANSI_CPP

endif

o.open(1, "insert into test_tab(f1,f2,f3,f4) "
" values(:f1<int>,:f2<char<span>[46]>,:f3<char<span>[200]>,:f4<char<span>[200]>)",
db);

o << 1<< "test1"<< "test2"<< "test3"; // insert success
o << 1<< "测试1"<< "测试2"<< "测试3"; // insert success when when DSN use EnableInsertCursors=0

o << 1<< "测试1"<< "测试2"<< "测试3";// insert fail when when DSN use EnableInsertCursors=1
// error data in database , f2= "测试1", but f3 and f4 is blank

This option improves the performance of bulk insert operations.
EnableInsertCursors=1