＋设为首页 ＋添加到收藏夹
在AIX下的C程序中，想调用oracle的存储过程，该如何调用，能否给个范例，谢谢！
//////在vc中编译时加载oraSQL8.lib文件
#pragma comment(lib,"oraSQL8.lib")
#include "stdio.h"
#include "string.h"
#include "stdlib.h"
EXEC SQL INCLUDE SQLCA;
//////////数据库联接
int Ora_conn()
{
EXEC SQL BEGIN DECLARE SECTION;
VARCHAR usr[20],pass[20],serv[20];
EXEC SQL END DECLARE SECTION;
EXEC SQL WHENEVER SQLERROR GOTO sqlerr;
strcpy(usr.arr,"lcj");
usr.len=(unsigned short)strlen((char*)usr.arr);
strcpy(pass.arr,"lcj");
pass.len=(unsigned short)strlen((char*)pass.arr);
strcpy(serv.arr,"zlodb");
serv.len=(unsigned short)strlen((char*)serv.arr);
EXEC SQL CONNECT :usr IDENTIFIED BY :pass USING :serv;
printf("Connect!\n");
return 1;
sqlerr:
EXEC SQL WHENEVER SQLERROR CONTINUE;
printf("%s\n",sqlca.sqlerrm.sqlerrmc);
return 0;
}
/////调用存储过程
call_p(userid)
{
EXEC SQL BEGIN DECLARE SECTION;
char userid_p[10];
EXEC SQL END DECLARE SECTION;
strcpy(userid_p,userid);
EXEC SQL EXECUTE
BEGIN
prtest(:userid_p,124,1234);
END;
END-EXEC;
}
void main()
{
EXEC SQL BEGIN DECLARE SECTION; /*sql中用到的变量*/
char userid[9];
int conn;
EXEC SQL END DECLARE SECTION;
conn=Ora_conn();
printf("请输入userid的值:\n");
scanf("%s",&userid);
call_p(userid);
}
在编译的时候加上SQLCHECK=SEMANTICS选项试试
proc iname=d:\ora_proc_test\OraTest.pc userid=用户名/密码@数据库 sqlcheck=semantics
