otl说明

Otl说明常用的类otl_connect初始化static int otl_initialize(const int threaded_mode=0);otl_connect(const char* connect_str,const int auto_commit=0);数据库连接管理void server_attach(const char* tnsname=0);// tnsname (TNS alias from TNSNAMES.ORA file) can// be specified, in order to connect to a remote// Oracle 8 server.// For local connections, tnsname gets// defaulted to 0.void server_detach(void);// detach from the Oracle 8 servervoid session_begin(const char* username, // user name, e.g. "scott"const char* password, // password, e.g. "tiger"const int auto_commit=0 // session auto-commit mode );void session_end(void);void session_reopen(const int aauto_commit=0// session auto-commit mode);事务操作：void commit(void);默认事务提交模式是非自动提交，必须显示使用commit进行提交void rollback(void);void auto_commit_off(void);void auto_commit_on(void);otl_streamotl_stream(const short arr_size, // stream buffer size（only for select can be set to 50, other cases it is 1）const char* sqlstm, // SQL statement or anynonymous PL/SQL block otl_connect& db, // OTL connect objectconst char* ref_cur_placeholder=0// If the stream returns a referenced cursor,// this parameter is used to specify the name of the // referenced cursor placeholder.);void open(const short arr_size, // stream buffer sizeconst char* sqlstm,// SQL statemnet or anynonymous PL/SQL blockotl_connect& db, // connect objectconst char* ref_cur_placeholder=0// If the stream returns a referenced cursor,// this parameter is used to specify the name of the // referenced cursor placeholder.);void close();int eof(void); //判断是否已到流尾void flush(void); //刷新缓冲区void clean(const int clean_up_error_flag=0); //清除流异常标志int is_null(void); //测试是否为空值long get_rpc(void); //更新数据条数otl_exception∙stm_text.First 2047 characters of the text of the SQL statement in which the otl_exception was raised.char stm_text[2048];∙var_info. In case if the OTL defined exception "Incompatible data types in stream operation" is raised, the var_info field is filled out with variable specificinformation: bind variable name / select output column number, its datatype and the datatype of the parameter of the operator >> or operator <<.char var_info[256];∙msg. The msg field contains a database error message or a message of an OTL defined exception.unsigned char msg[1000];∙code. The code field contains a database error code or a code of an OTL defined exceptionint code;∙sqlstate. The sqlstate field is used in OTL 3.2/ODBC and OTL/DB2-CLI only.It is always empty in OTL 3.2/OCIx. In OTL 3.2/ODBC and OTL/Db2-CLI, the field contains the sqlstate information, the way it is defined in ODBC. For more detail, see the ODBC Programmer's Guide, the DB2 CLI Programmer’s Guide.unsigned char sqlstate[1000];∙enum. This enum defines two constants which may be used in execution of constant SQL statementsenum{disabled=0,enabled=1};执行sqlotl_cursor::direct_exec(db, // connect object"create table test_tab(f1 number, f2 varchar2(30))"); // create table通过otl_stream执行。

对于update操作应该将缓冲区的大小设置为1存储过程的调用方法BEGIN:rc<int,out> := my_func(:salary<float,in>,:ID<int,inout>,:name<char[32],out>);END;NULL值的处理Otl_nullOtl_stream.is_null()异常恢复机制otl_stream.clearn (error_no)例子程序#include <iostream.h>#include <stdio.h>#define OTL_ORA8I // Compile OTL 3.1/OCI8#include <otlv31.h> // include the OTL 3.1 header fileotl_connect db; // connect objectvoid insert()// insert rows into table{otl_stream o(50, // buffer size"insert into test_tab values(:f1<float>,:f2<char[31]>)", // SQL statementdb // connect object);char tmp[32];for(int i=1;i<=100;++i){sprintf(tmp,"Name%d",i);o<<(float)i<<tmp;}}void select(){otl_stream i(50, // buffer size"select * from test_tab where f1>=:f<int> and f1<=:f*2", // SELECT statementdb // connect object);// create select streamfloat f1;char f2[31];i<<8; // assigning :f = 8// SELECT automatically executes when all input variables are// assigned. First portion of output rows is fetched to the bufferwhile(!i.eof()){ // while not end-of-datai>>f2>>f1; // a typo: f2 instead of f1cout<<"f1="<<f1<<", f2="<<f2<<endl;}i<<4; // assigning :f = 4// SELECT automatically executes when all input variables are// assigned. First portion of output rows is fetched to the bufferwhile(!i.eof()){ // while not end-of-datai>>f1>>f2;cout<<"f1="<<f1<<", f2="<<f2<<endl;}}int main(){otl_connect::otl_initialize(1); // initialize OCI environmenttry{db.rlogon("aicbs/ccs1234@TESTCS2"); // connect to Oracleotl_cursor::direct_exec(db,"drop table test_tab",otl_exception::disabled // disable OTL exceptions); // drop tableotl_cursor::direct_exec(db,"create table test_tab(f1 number, f2 varchar2(30))"); // create tableinsert(); // insert records into tableselect(); // select records from table}catch(otl_exception& p){ // intercept OTL exceptionscerr<<p.msg<<endl; // print out error messagecerr<<p.stm_text<<endl; // print out SQL that caused the errorcerr<<p.var_info<<endl; // print out the variable that caused the error }db.logoff(); // disconnect from Oraclereturn 0;}。