#include <iostream.h> #include <stdio.h>
#define OTL_ORA8 // Compile OTL 4.0/OCI8 #include <otlv4.h> // include the OTL 4.0 header file otl_connect db; // connect object void insert() // insert rows into table { otl_stream o(200, // buffer size "insert into test_tab values(:f1<float>,:f2<char[31]>)", // SQL statement db // connect object ); char tmp[32]; for(int i=1;i<=123;++i){ sprintf(tmp,"Name%d",i); o<<(float)i<<tmp; } o.flush(); cout<<"Rows inserted: "<<o.get_rpc()<<endl; } void delete_rows() { long rpc=otl_cursor::direct_exec(db,"delete from test_tab where f1>=95"); cout<<"Rows deleted: "<<rpc<<endl; } int main() { otl_connect::otl_initialize(); // initialize OCI environment try{ db.rlogon("scott/tiger"); // connect to Oracle otl_cursor::direct_exec ( db, "drop table test_tab", otl_exception::disabled // disable OTL exceptions ); // drop table otl_cursor::direct_exec ( db, "create table test_tab(f1 number, f2 varchar2(30))" ); // create table insert(); // insert records into table delete_rows(); // select records from table } catch(otl_exception& p){ // intercept OTL exceptions cerr<<p.msg<<endl; // print out error message cerr<<p.stm_text<<endl; // print out SQL that caused the error cerr<<p.var_info<<endl; // print out the variable that caused the error } db.logoff(); // disconnect from Oracle return 0; }
Rows inserted: 123 Rows deleted: 29
Copyright © 1996, 2001, Sergei Kuchin, email: skuchin@sprynet.com, kuchin@hotmail.com.
Permission to use, copy, modify and redistribute this document for any purpose is hereby granted without fee, provided that the above copyright notice appear in all copies.