proc开发
文章平均质量分 69
linlin1023
这个作者很懒,什么都没留下…
展开
-
proc调用存储过程
<br />/*<br /> *功能:proc调用存储过程<br /> *源文件:procedure.pc<br /> */<br /> <br />#include<stdio.h><br />#include<unistd.h><br />#include<stdlib.h><br />/*#define SQLCA_NONE*/<br />EXEC SQL INCLUDE SQLCA;<br />EXEC SQL BEGIN DECLARE SECTION;<br /> char db_name原创 2010-06-30 21:33:00 · 4235 阅读 · 0 评论 -
proc的delete操作
/* *功能:proc的insert操作 *源文件:insert.pc */#include#include#includeEXEC 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; sp原创 2010-06-22 21:12:00 · 2978 阅读 · 0 评论 -
proc的update操作
<br />/*<br /> *功能:proc的update操作<br /> *源文件:update.pc<br /> */<br />#include<stdio.h><br />#include<unistd.h><br />#include<stdlib.h><br />EXEC SQL INCLUDE SQLCA;<br />EXEC SQL BEGIN DECLARE SECTION;<br /> char db_name[25] = "dbname";<br />EXEC SQL END原创 2010-06-22 21:23:00 · 945 阅读 · 0 评论 -
proc的select操作
/* *功能:proc的select操作 *select.pc */#include#include#includeEXEC 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原创 2010-06-20 20:28:00 · 928 阅读 · 0 评论 -
proc连接操作
/* *功能:利用C/C++连接Oracle *源文件:conn.pc */#include#include#include#includeEXEC SQL INCLUDE SQLCA;void errorHandle(char *sm){ char buf[1024]; long bufLen,msgLen,fc; sprintf(buf, "执行数据库操作(%s)失败, ORA ERROR:%.70s, SQLCA.SQLCODE=%d", sm, sqlca.sqlerrm.s原创 2010-06-20 11:31:00 · 513 阅读 · 0 评论 -
proc的insert操作
/* *proc的insert操作 *源文件:insert.pc */#include#include#includeEXEC 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; spr原创 2010-06-20 20:40:00 · 1431 阅读 · 0 评论 -
proc的makefile文件
#makefile for procSOURCE=deleteDBLINK=nmc/nmc@atest_229$(SOURCE): $(SOURCE).cpp g++ -g -o $(SOURCE) $(SOURCE).cpp -L$ORACLE_HOME/lib -I$(XERCESCROOT)/include/ -lclntsh$(SOURCE).cpp: $(SOURCE).pc proc SQLCHECK=SEMANTICS code=cpp include=/usr/i原创 2010-06-30 21:42:00 · 813 阅读 · 0 评论 -
proc的动态游标操作
<br />/*<br /> *功能:proc的动态游标操作<br /> *源文件:dyn_cursor.pc<br /> */<br /> <br />#include<stdio.h><br />#include<unistd.h><br />#include<stdlib.h><br />/*#define SQLCA_NONE*/<br />EXEC SQL INCLUDE SQLCA;<br />EXEC SQL BEGIN DECLARE SECTION;<br /> char db_na原创 2010-06-30 21:38:00 · 2300 阅读 · 0 评论 -
proc的游标操作
<br />/*<br /> *功能:proc的游标操作<br /> *源文件:cursor.pc<br /> */<br /> <br />#include<stdio.h><br />#include<stdlib.h><br />#include<unistd.h><br />EXEC SQL INCLUDE SQLCA;<br />/*#define SQLCA_NONE<br /> static struct sqlca sqlca;<br />*/<br />int main()<br />原创 2010-06-30 21:30:00 · 846 阅读 · 0 评论 -
proc动态插入操作
<br />/* <br /> *功能:proc动态插入操作 <br /> *源文件:dyn_insert.pc<br /> */<br /> <br />include<stdio.h><br />#include<unistd.h><br />#include<stdlib.h><br />/*#define SQLCA_NONE*/<br />EXEC SQL INCLUDE SQLCA;<br />EXEC SQL BEGIN DECLARE SECTION;<br /> char db_na原创 2010-06-30 21:37:00 · 763 阅读 · 0 评论 -
proc获取字符串值
/* *我们从数据库中取字符串值时,后面会有许多空格,需要特别注意 * */#include#include#include#include/*#define SQLCA_NONE*/EXEC SQL INCLUDE SQLCA;int main(){ EXEC SQL BEGIN DECLARE SECTION; int sysid; int intId;原创 2010-08-22 21:44:00 · 632 阅读 · 0 评论