/*
*功能: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