ASE15数据库存储过程的问题

[Yellho]

存储过程如下,

create procedure dbo.dayknot_czy(@czy varchar(35),@jzrq datetime)
/* [ (@param_name datatype [= default] [output] ), ... ] */
with recompile
as
begin
update register set jzrq= @jzrq,jzbz = '1' where sfrydm = @czy and jzbz = '0'
update serprice set jzsj = @jzrq,yjz = '1' where sfydm = @czy and yjz = '0' and yjs = '1'
update medph set jzsj = @jzrq,yjz = '1' where sfydm = @czy and yjz = '0' and yjs = '1'
update hosdeposit set jzsj = @jzrq,yjz = '1' where sfydm = @czy and yjz = '0'
update dayknot set jzrq = @jzrq,yjz = '1' where sfydm = @czy and yjz = '0'
update buscrm set jzsj = @jzrq, yjz = '1' where sfrydm = @czy and yjz = '0'
end

用isql执行 exec dbo.dayknot_czy('test','2010.01.01 00:00:00') 可以成功,并且数据更新没有问题;


在开发的程序中如此调用,

DECLARE Emp_proc procedure for dayknot_czy @czy = :gczy, @jzrq = :jzrq ;
EXECUTE Emp_proc;

提示如下错误

存储过程'dayknot_czy' 只能运行在非链式事务模式下,'set chained off'命令造成当前会话使用非链式事务模式.

在调用存储过程前 用了 set chained off 命令,还是提示上面的错误.

请高手速解,万分感谢!!!

[fourthboy]

EXEC sp_procxmode 'dayknot_czy','anymode'
go