有重分,不够以后还给!ASA的存储过程问题!高手来吧!
CREATE PROCEDURE lv_sc_insert @khhh Varchar(10),@scdh VarChar(12)
AS
begin
begin tran
insert into produce_bz(scdh,t_plsm,t_scsm,t_xcm,p_main,p_size,p_xzm)
select @scdh,b.t_plsm,b.t_scsm,b.t_xcm,b.p_main,b.p_size,b.p_xzm
from yb_produce b
where b.khhh = @khhh
If (@@error = 0 )
begin
commit tran
return 1
end
else
begin
rollback tran
return @@error +1
end
end;
在程序中之行的时候报错,
SQLSTATE = S0002
[Sybase][ODBC Driver][Adaptive Server Anywhere]Table or view not found: Table 'produce_bz' not found
表produce_bz中的字段p_main,p_size,p_xzm是在Sql 2000 中的image字段,转到ASA中是long binary类型的。
上述存储过程在sql 2000 中正常,在ASA中报上述错误!