Oracle10G－－PROC编程篇（Linux）

PROC编程相信在Linux下工作的朋友应该不陌生吧！下面就来具体介绍些Proc编程相关的东西，此文相对简单，请高手们绕行。
PROC编程篇
（此文仅供Oracle初学者参考只用）
/**********************************************
** 文章名称：Oracle10G－－PROC编程篇（Linux）
** 版权信息：可以任意转载，但要注明出处及作者信息

***********************************************/
一、简单取得系统时间


#include
#include
#include
EXEC SQL INCLUDE sqlca;
EXEC SQL INCLUDE oraca;
main( int argc, char *argv[] )
{
EXEC SQL BEGIN DECLARE SECTION;
varchar vcBuffer[32];
EXEC SQL END DECLARE SECTION;
/* Connect To Oracle Datebaase */
if(OU_ConnectDatabase("weigw","weigw") != 0)
{
printf("Connect Database failed!\n");
return -1;
}
memset(vcBuffer.arr, 0x00, sizeof(vcBuffer.arr));
EXEC SQL select sysdate into :vcBuffer from dual;
printf("SYSDATE:\n", vcBuffer.arr);
EXEC SQL COMMIT WORK RELEASE;
return 0;
}
/*
**
** 功能说明：连接数据库
** 输入参数：
** 输入参数：
** 输出参数：
** 返回值说明：0－成功 其他－失败
*/
int OU_ConnectDatabase(char *con_name,char *con_passwd)
{
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR uid[20];
VARCHAR pwd[20];
EXEC SQL END DECLARE SECTION;
strcpy(uid.arr,con_name); /*strcpy(uid.arr,"weigw");*/
uid.len=strlen(uid.arr);
strcpy(pwd.arr,con_passwd); /*strcpy(pwd.arr,"weigw");*/
pwd.len=strlen(pwd.arr);
EXEC SQL CONNECT :uid IDENTIFIED BY :pwd ;
return sqlca.sqlcode;
}
二、多库用户操作（排他锁）
#include
#include
#include
EXEC SQL INCLUDE sqlca;
EXEC SQL INCLUDE oraca;
main( int argc, char *argv[] )
{
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR vcBuffer[32];
int ID;
const char *dbname1 = "dbname1";
const char *dbname2 = "dbname2";
EXEC SQL END DECLARE SECTION;
/* Connect To Oracle Datebaase dbname1 */
if(OU_ConnectDatabase("weigw","weigw","orcl","dbname1") != 0)
{
printf("Connect Database failed!\n");
return -1;
}

/* Connect To Oracle Datebaase dbname2 */
if(OU_ConnectDatabase("weigw","weigw","orcl","dbname2") != 0)
{
printf("Connect Database dbname 2 failed!\n");
return -1;
}
ID = 0;
memset(vcBuffer.arr, 0x00, sizeof(vcBuffer.arr));
vcBuffer.len = 0;
EXEC SQL AT :dbname1 SELECT COUNT(*) INTO :ID FROM WEIGWTEST;
ID += 1;
strncpy(vcBuffer.arr, "dbname1", sizeof(vcBuffer.arr) - 1);
vcBuffer.len = strlen(vcBuffer.arr);
EXEC SQL AT :dbname1 INSERT INTO WEIGWTEST VALUES(:ID, :vcBuffer);
EXEC SQL AT :dbname2 INSERT INTO WEIGWTEST VALUES(:ID, :vcBuffer);
EXEC SQL AT :dbname1 COMMIT;
EXEC SQL AT :dbname1 ROLLBACK;
EXEC SQL COMMIT WORK RELEASE;
return 0;
}
/*
**
** 功能说明：连接数据库
** 输入参数：
** 输入参数：
** 输出参数：
** 返回值说明：0－成功 其他－失败
*/
int
OU_ConnectDatabase(
char *con_name,
char *con_passwd,
char *con_string,
char *con_dbname
) {
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR uid[20];
VARCHAR pwd[20];
VARCHAR sid[20];
VARCHAR dbname[20];
EXEC SQL END DECLARE SECTION;
memset(uid.arr, 0x00, sizeof(uid.arr));
uid.len = 0;
memset(pwd.arr, 0x00, sizeof(pwd.arr));
pwd.len = 0;
memset(sid.arr, 0x00, sizeof(sid.arr));
sid.len = 0;
memset(dbname.arr, 0x00, sizeof(dbname.arr));
dbname.len = 0;
strcpy(uid.arr,con_name);
uid.len=strlen(uid.arr);
strcpy(pwd.arr,con_passwd);
pwd.len=strlen(pwd.arr);
strcpy(sid.arr,con_string);
sid.len=strlen(sid.arr);
strcpy(dbname.arr,con_dbname);
dbname.len=strlen(dbname.arr);
EXEC SQL CONNECT :uid IDENTIFIED BY :pwd AT :dbname USING :dbname;
return sqlca.sqlcode;
}