OCI方面的知识，哪位高手能帮忙修改下 想批量插入数据，且表的字段很多

/*************************编译语句gcc -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -I${ORACLE_HOME}/rdbms/public -I${ORACLE_HOME}/rdbms/demo -L${ORACLE_HOME}/lib -lclntsh  test1.cOCI重定义数据类型：typedef unsigned     char         ub1;typedef signed     char         sb1;typedef unsigned     short     ub2;typedef signed     short     sb2;typedef unsigned     int         ub4;typedef signed     int         sb4;typedef ub4                     duword;typedef sb4                     dsword;typedef dsword                 dword;*************************/#include <stdio.h>#include <stdlib.h>#include <string.h>#include <oci.h>/*user name and password*/static text* username=(text *)"scott";static text* password=(text *)"tiger";static text* oracle=(text *)"orcl";/* Define SQL statements to be used in program. */ static text* SQL=(text *)"insert into tab1(id, name) values (:1, :2)";/*handle define*/static OCIEnv             *p_env;                                        //OCI environment handlestatic OCIError         *p_err;                                        //OCI error handlestatic OCISvcCtx        *p_svc;                                        //OCI service context handelstatic OCIServer        *p_ser;                                        //OCI server handlestatic OCISession        *p_usr;                                        //OCI user session handlestatic OCIStmt            *p_sql;                                        //OCI statement handlestatic OCIDefine        *p_dfn = (OCIDefine *)NULL;            //OCI define handlestatic OCIBind            *p_bnd = (OCIBind *)NULL;                //OCI bind handle/*create OCI environment*/int create_env(){    int swResult;            //Return value        if(swResult = OCIEnvCreate(&p_env,OCI_DEFAULT,NULL,NULL,NULL,NULL,0,NULL))        {            printf("environment create error!\n\n");            return -1;        }    else         {            printf("environment create success!\n\n");            return 0;        }}/*init handle*/int init_handle(){    int swResult;    if(swResult = OCIHandleAlloc(p_env,(dvoid *)&p_ser,OCI_HTYPE_SERVER,0,NULL))    //服务器句柄        {            printf("init server handle error!\n\n");            return -1;        }    else        {            printf("init server handle success!\n\n");        }    if(swResult = OCIHandleAlloc(p_env,(dvoid *)&p_err,OCI_HTYPE_ERROR,0,NULL))    //错误句柄        {            printf("init error handle error!\n\n");            return -1;        }    else        {            printf("init error handle success!\n\n");        }    if(swResult = OCIHandleAlloc(p_env,(dvoid *)&p_usr,OCI_HTYPE_SESSION,0,NULL))    //事务句柄        {            printf("init session handle error!\n\n");            return -1;        }    else        {            printf("init session handle success!\n\n");        }    if(swResult = OCIHandleAlloc(p_env,(dvoid *)&p_svc,OCI_HTYPE_SVCCTX,0,NULL))    //上下文句柄        {            printf("init service context handle error!\n\n");            return -1;        }    else        {            printf("init service context handel success!\n\n");        }    if(swResult = OCIHandleAlloc(p_env,(dvoid *)&p_sql,OCI_HTYPE_STMT,0,NULL))        //SQL语句句柄        {            printf("init statement handle error!\n\n");            return -1;        }    else        {            printf("init statement handle success!\n\n");        }    return 0;}/*connect server*/int conn_server(){    int swResult;    if(swResult = OCILogon(p_env,p_err,&p_svc,(text *)username,strlen(username),(text *)password,strlen(password),(text *)oracle,strlen(oracle)))        {            printf("connect error!\n\n");            return -1;        }    else         printf("connect success!\n\n");    return 0;}/*SQL statements*/int oci_exec(){    int swResult;    //准备SQL语句    if(swResult = OCIStmtPrepare(p_sql,p_err,SQL,strlen(SQL),OCI_NTV_SYNTAX,OCI_DEFAULT))        {            printf("prepare SQL statements error!\n\n");        }    else        {            printf("prepare SQL statements success!\n\n");        }    //设置绑定变量    int getId ;    char getName[10];        OCIBind     *p_bndp1 = NULL;    OCIBind     *p_bndp2 = NULL;        printf("输入ID,NAME:\n");    scanf("%d %s",&getId,getName);        if(swResult = OCIBindByPos(p_sql,&p_bndp1,p_err,1,(dvoid *)&getId,(sb4)sizeof(getId),SQLT_INT,NULL,NULL,NULL,0,NULL,OCI_DEFAULT))        {            printf("Bind p1 error!\n\n");            return -1;        }    else         {            printf("bind success!\n\n");        }        if(swResult = OCIBindByPos(p_sql,&p_bndp2,p_err,2,&getName,(sb4)sizeof(getName),SQLT_STR, (dvoid *) 0, (ub2 *) 0, (ub2 *) 0, (ub4) 0, (ub4 *) 0, OCI_DEFAULT))        {            printf("Bind p2 error!\n\n");            return -1;        }    else         {            printf("bind success!\n\n");        }    //执行SQL statements    if(swResult = OCIStmtExecute(p_svc,p_sql,p_err,1,0,NULL,NULL,OCI_DEFAULT))        {            printf("execute SQL statement error!\n\n");            return -1;        }    else        {            printf("execute SQL statement success!\n\n");        }    return 0;}/*quit server*/void quit_server(){    OCILogoff(p_svc,p_err);    printf("Quit success!\n");}/*free handle*/void free_handle(){    OCIHandleFree(p_ser,OCI_HTYPE_SERVER);            //释放服务器句柄    OCIHandleFree(p_err,OCI_HTYPE_ERROR);            //释放错误句柄    OCIHandleFree(p_usr,OCI_HTYPE_SESSION);        //释放事务句柄    OCIHandleFree(p_svc,OCI_HTYPE_SVCCTX);            //释放上下文句柄    OCIHandleFree(p_sql,OCI_HTYPE_STMT);            //释放SQL语句句柄}int main(){    if(create_env() == -1)                //创建环境        return -1;    if(init_handle() == -1)                //初始化句柄        return -1;    if(conn_server() == -1)                //连接数据库        return -1;    if(oci_exec() == -1)        return -1;    quit_server();                            //退出数据库    free_handle();                            //释放句柄    return 0;}