- 博客(10)
- 收藏
- 关注
原创 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 812
原创 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 2299
原创 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 762
原创 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 4234
原创 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 843
原创 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 944
原创 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 2977
原创 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 1430
原创 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 927
原创 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 512
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人