免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 4502 | 回复: 1

求助, pro*c 和gcc编译都没问题, buildserver出错 [复制链接]

论坛徽章:
0
发表于 2010-09-10 08:20 |显示全部楼层
20可用积分
[oracle@Tux10M simpapp]$ buildserver -f fetch.c -o fetch -s FETCH
fetch.c:147:20: sqlcpr.h: No such file or directory
CMDTUX_CAT:1832: ERROR: can't execute cc -m32   -I$TUXDIR/include -o fetch BS-5366.c  -L${TUXDIR}/lib fetch.c  -ltux -lbuft   -lfml -lfml32 -lengine -ldl -lpthread  
[oracle@Tux10M simpapp]$

论坛徽章:
0
发表于 2010-09-10 08:57 |显示全部楼层
***************************my .pc file like below

[oracle@Tux10M simpapp]$ more fetch.pc
#include <stdio.h>
#include <string.h>
#include <stdlib.h>
#include <sqlda.h>
#include <sqlcpr.h>
#include <atmi.h>
#include <fml.h>
#include <userlog.h>

/* config pro*c operation */
EXEC SQL INCLUDE sqlca;
EXEC SQL INCLUDE oraca;
EXEC ORACLE OPTION(oraca=yes);

/* define constants for varchar length*/
#define UNAME_LEN 20
#define PWD_LENTH 40

/* declare variable, no declare section is needed, if MODE=ORACLE */
VARCHAR username[UNAME_LEN];
varchar password[PWD_LENTH];/*varchar is an oracle-supplied struct, can be lower and upper case*/

/* declare error handling function*/
void sql_error(char *msg)
{
char err_msg[128];
size_t buf_len, msg_len;

EXEC SQL WHENEVER SQLERROR CONTINUE;

printf("\n %s \n", msg);
buf_len = sizeof(err_msg);
sqlglm(err_msg, &buf_len, &msg_len);
if(msg_len > buf_len)
{
msg_len = buf_len;
}
printf("%.*s\n", msg_len, err_msg);

EXEC SQL ROLLBACK RELEASE;
exit(1);
}
main()
{
EXEC SQL INCLUDE sqlca;
EXEC ORACLE OPTION(RELEASE_CURSOR = YES);
/* register the sql_error() as the error handler*/
EXEC SQL WHENEVER SQLERROR DO sql_error("ORACLE error-- \n");

EXEC SQL BEGIN DECLARE SECTION;
char oraCN[50];
EXEC SQL END DECLARE SECTION;

strcpy(oraCN, "scott/scott@jerry");

EXEC SQL CONNECT :oraCN;
printf("\n Connected to ORACLE as user: %s \n", oraCN);

/* disconnect from ORACLE*/
EXEC SQL ROLLBACK WORK RELEASE;

return 0;
}

[oracle@Tux10M simpapp]$
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP