/*
*proc的insert操作
*源文件:insert.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 insert()
{
EXEC SQL BEGIN DECLARE SECTION;
int sysid = 142857;
EXEC SQL END DECLARE SECTION;
EXEC SQL WHENEVER SQLERROR DO errorHandle("insert object_ex error");
EXEC SQL AT :db_name INSERT INTO object_ex(sys_int_id)
VALUES (:sysid);
EXEC SQL AT :db_name COMMIT WORK;
printf("insert database ok/n");
}
int main()
{
connect();
printf("Connect database ok/n");
insert();
disconnect();
printf("Disconnect database ok/n");
return 0;
}