occi获取表，列，类型

create table temp_test(iid_number number, name_varchar2 varchar2(32), 
                        num_53 number(5,3), char_5 char(5), long_type long, raw_20 raw(20), 

blob_type blob, integer_type integer , stat_time_date date);
 

Environment *env; 

  Connection *conn; 
  Statement *stmt;

  ResultSet *rs;

env = Environment::createEnvironment();//创建环境变量
  conn = env->createConnection(username,password,connstring); //创建数据库连接对象
  stmt = conn->createStatement();//创Statement对象

string sql = "select * from temp_test";
stmt->setSQL(sql);//准备SQL语句

// 逐行获取表字段

try

{

                 rs =  stmt->executeQuery();//执行SQL语句，返回结果集