Linux c 查询Oracle数据库例子

/*  * File:   main.c * Author: oracle * * Created on October 11, 2012, 3:14 AM */#include <stdio.h>#include <stdlib.h>#include "sqlora.h"/* *  */int main(int argc, char** argv) {sqlo_db_handle_t dbh;int sd;int sth;const char *cstr = "xia/pass123@DBInstance";const char **v;if (SQLO_SUCCESS != sqlo_init(SQLO_OFF,1,100))                    {            printf ("sql_init failed. Exiting\n");          exit(1);  }  if (SQLO_SUCCESS != sqlo_connect(&dbh, cstr)){        printf ("connect failed. Exiting\n");          exit(1); }else{        printf ("connect successfully. Exiting\n");  }char *select_stmt="SELECT * FROM status";  if (0>(sd=sqlo_open(dbh, select_stmt, 0, NULL)))  {           printf("open table failed: %s\n", sqlo_geterror(dbh));          return 0;  }else{        printf("open table");}printf("\n");while(0==sqlo_fetch(sd,1)){        v=sqlo_values(sd,NULL,1);    printf("Result is : %s %s %s %s %s %s\n",v[0],v[1],v[2],v[3],v[4],v[5]);}sqlo_finish(dbh);return (EXIT_SUCCESS);}