Error converting data type varchar to bit.
大家帮忙看看   哈  

set   ANSI_NULLS   ON
set   QUOTED_IDENTIFIER   ON
go


--   =============================================
--   Author: <Author,,Name>
--   Create   date:   <Create   Date,,>
--   Description: <Description,,>
--   =============================================
ALTER   PROCEDURE   [todb].[SPW_Gacha_CouponUpdateUseCoupon]
(
@coupon_code   int,
@is_win   tinyint,
@world_code   tinyint,
@account_gid   varchar(100),
@goods_code   int,
@limit_code   smallint,
        @field_coupon_code   int,
        @drill_coupon_code   int,
        @gacha_item_type   bit,
        @gacha_version   int,
@field_num   int
)
AS
declare   @rvalue   int
exec   @rvalue=TO_ACCOUNT_DB.gmg_account.dbo.uspn_gacha_coupon_update_use_coupon   @coupon_code,@is_win,@world_code,@account_gid,@goods_code,@limit_code,@field_coupon_code,@drill_coupon_code,@gacha_item_type,@field_num,@gacha_version
return   @rvalue

调用时候报错

DECLARE @return_value   int

EXEC @return_value   =   [todb].[SPW_Gacha_CouponUpdateUseCoupon]
@coupon_code   =   100204009,
@is_win   =   2,
@world_code   =   1,
@account_gid   =   N 'n118 ',
@goods_code   =   19502,
@limit_code   =   2,
@field_coupon_code   =   0,
@drill_coupon_code   =   0,
@gacha_item_type   =   0,
@gacha_version   =   1,
@field_num   =   1

SELECT 'Return   Value '   =   @return_value

GO


@gacha_item_type   =   0,这个参数是bit类型的，到底怎么调用   呢   》？


------解决方案--------------------
检查你调用uspn_gacha_coupon_update_use_coupon的参数顺序是否正确
------解决方案--------------------
问题可能出在

exec @rvalue=TO_ACCOUNT_DB.gmg_account.dbo.uspn_gacha_coupon_update_use_coupon @coupon_code,@is_win,@world_code,@account_gid,@goods_code,@limit_code,@field_coupon_code,@drill_coupon_code,@gacha_item_type,@field_num,@gacha_version