script for create table: create table test_tab(f1 int, f2 VARCHAR(200), f3 VARCHAR(200), f4 VARCHAR(200) )
base unixODBC and define:
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
Log in to post a comment.
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