一个Sybase存储过程问题-------执行时出错,请大虾们进来看看
我要做的时,通过一个存储过程dbo.T_KJ_SWDJTJB调用另一个存储过程dbo.T_KJ_GET_SQL_SWDJTJB ,dbo.T_KJ_GET_SQL_SWDJTJB 将会返回一个SQL语句.
在dbo.T_KJ_SWDJTJB中,执行这个sql
请大家帮我看看 错在哪了

存储过程代码:
CREATE PROCEDURE dbo.T_KJ_SWDJTJB

@is_sjyf VARCHAR(6)

as

DECLARE

@ROWCOUNT INT,
@vs_xh VARCHAR(4),
@vs_xm VARCHAR(100),
@vs_bm VARCHAR(50),
@vs_tj VARCHAR(3000),
@vs_sql VARCHAR(10000),
@COMMITCOUNT INT

select @ROWCOUNT = 0
select @COMMITCOUNT = 0

BEGIN

--定义游标
DECLARE V_CUR CURSOR FOR
select XH,XM,BM,TJ from T_CS_KJ_SWDJTJB order by XH




--循环
OPEN V_CUR

FETCH V_CUR INTO @vs_xh,@vs_xm,@vs_bm,@vs_tj

WHILE @@SQLSTATUS != 2

BEGIN

EXEC dbo.T_KJ_GET_SQL_SWDJTJB @is_sjyf,@vs_bm,@vs_xh,@vs_xm,@vs_tj,@vs_sql output

IF @vs_sql IS NOT NULL
BEGIN
EXEC @vs_sql
END



FETCH V_CUR INTO @vs_xh,@vs_xm,@vs_bm,@vs_tj
END
CLOSE V_CUR

IF @@ERROR <> 0
BEGIN
ROLLBACK TRAN
RETURN -200
END


PRINT 'SUCCESS '
PRINT @vs_sql

END
RETURN 0


出错信息:
Error: Number (2812) Severity (16) State (8) Server (ESZDS) Procedure (T_KJ_SWDJTJB) Stored procedure 'insert into dbo.T_KJ_SWDJTJB_BO(

SJRQ,
GLJG_DM,
XH,
XM,
NLMY_SL ,

CKY_SL,
ZZY_SL,
DL_SL,
JZY_SL ,
JTYSY_SL ,
XXCS_SL ,
PFLS_SL ,
ZSCY_SL ,
' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
, Batch 1 Line 43

[解决办法]
EXEC (@vs_sql)