variable
sqlcode varchar2;
sqlerrm varchar2;
exec stzo0100.chkidousyori(5650,9212001,92101,0,0,SYSDATE,0, :sqlcode, :sqlerrm);
print sqlcode
print sqlerrm
sqlcode varchar2;
sqlerrm varchar2;
exec stzo0100.chkidousyori(5650,9212001,92101,0,0,SYSDATE,0, :sqlcode, :sqlerrm);
print sqlcode
print sqlerrm
Select A.x1,A.x2,A.x3,
stzo0100.chkidousyori(A.x5,A.A.x6,A.x7,A.x8,A.x9,A.SYSDATE,0),
B.y1,B.y2
from A,B
WHER A.xn=B.yn
但是这时,总是报传的参数不正确,我对过了,类型肯定对的,就是不知道,参数是不是这样传的
....
当然不对了
-.-
stzo0100.chkidousyori(A.x5,A.A.x6,A.x7,A.x8,A.x9,SYSDATE,0),
B.y1,B.y2
from A,B
WHER A.xn=B.yn