/*
*功能:proc的update操作
*源文件:update.pc
*/
#include<stdio.h>
#include<unistd.h>
#include<stdlib.h>
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;
}
void update()
{
EXEC SQL BEGIN DECLARE SECTION;
int sysid = 142857;
EXEC SQL END DECLARE SECTION;
EXEC SQL WHENEVER SQLERROR DO errorHandle("update object_ex error");
EXEC SQL AT :db_name UPDATE object_ex
SET sys_int_id = :sysid
WHERE int_id = 10;
EXEC SQL AT :db_name COMMIT WORK;
printf("insert database ok/n");
}
int main()
{
connect();
printf("Connect database ok/n");
update();
disconnect();
printf("Disconnect database ok/n");
return 0;
}