- 论坛徽章:
- 0
|
我要做一个informix的procedure,我的做法:
先写一个简单c程序a.c:
#include<stdio.h>;
prthello(){
& & &printf("hello" ;
}
编译:
cc +z &a.c
生成动态库
ld -b -o a.sl a.o
在informix中执行:
create procedure a()
external name "$path/a.sl(a)"
language c
end procedure;
没有报错
然后在c程序b.c中调用:
exec sql include sqlca;
main(){
& &exec sql database $dbnane;
& &exec sql execute procedure a;
& &if(sqlca.sqlcode){
& & & printf("error,%d\n",sqlca.sqlcode);
& & & exit(1);
& &}
& & exit(0);
}
编译cc b.c 生成a.out可执行文件
当执行a.out,返回错误,错误码为9793
A bad external name, missing file, or wrong permissions might cause this
error.
哪位高手,伸一下手啊! |
|