proc动态插入操作

来源：互联网发布：java内存泄露的原因编辑：程序博客网时间：2024/04/30 02:26

*功能：proc动态插入操作

*源文件：dyn_insert.pc

include<stdio.h>
#include<unistd.h>
#include<stdlib.h>
/*#define SQLCA_NONE*/

EXEC SQL INCLUDE SQLCA;

EXEC SQL BEGIN DECLARE SECTION;
char db_name[25] = "dbname";
EXEC SQL END DECLARE SECTION;

void errorHandle(char *sm)
{
char buf[1024];
long bufLen,msgLen,fc;

sprintf(buf, "执行数据库操作(%s)失败, ORA ERROR:%.70s, SQLCA.SQLCODE=%d", sm, sqlca.sqlerrm.sqlerrmc, sqlca.sqlcode);

    printf("%s/n", buf);
    EXEC SQL WHENEVER SQLERROR CONTINUE;
    EXEC SQL AT :db_name ROLLBACK WORK;

return;
}

void connect()
{
    EXEC SQL BEGIN DECLARE SECTION;
    char connString[25] = "nmc/nmc@atest_229";
    EXEC SQL END DECLARE SECTION;

EXEC SQL WHENEVER SQLERROR DO errorHandle("Connect Database");
EXEC SQL AT :db_name CONNECT :connString;
}

void disconnect()
{
EXEC SQL WHENEVER SQLERROR DO errorHandle("Disconnect Database");
EXEC SQL AT :db_name COMMIT WORK RELEASE;
}

int main()
{

    EXEC SQL BEGIN DECLARE SECTION;
        VARCHAR sql_string[1024];
        int id;
    EXEC SQL END DECLARE SECTION;

printf("Input the sys_int_id: ");
scanf("%d", &id);

connect();

    EXEC SQL WHENEVER SQLERROR DO errorHandle("insert error");
    //动态构造SQL语句
    sql_string.len = sprintf((char *)sql_string.arr,"insert into objects_exs(sys_int_id) values(%d)", id);

    EXEC SQL AT :db_name EXECUTE IMMEDIATE :sql_string;
    //提交insert操作
    EXEC SQL AT :db_name COMMIT WORK;

    disconnect();
    printf("insert successful/n");
    return 0;
}

运行结果：

fj81db:/nmc/cdma_nmc/linlin/Proc$ insert
Input the sys_int_id: 142857
insert successful