i have store procedure , run correctly. can login database using remote connection. installed sqljdbc.jar , added tomcat/common/lib .but when run application, couldn't store procedure's results database. error message " value not set parameter number 0." how can solve problem?
alter procedure [dbo].[sp_mesaikontrol] @mesai_durum nvarchar(20) output, @hangi_gun nvarchar(10) output, @menu nvarchar(20) begin declare @tod int; declare @gun nvarchar(10); declare @haftaici_min nvarchar(5); declare @haftaici_max nvarchar(5); declare @haftasonu_min nvarchar(5); declare @haftasonu_max nvarchar(5); declare @menu_ad nvarchar(20); set @tod = (select (100*datepart(hour,getdate())+ datepart(minute,getdate()))) set @gun=(select dbo.udf_dayofweek(getdate())); set @haftaici_min =(select haftaici_min dbo.mesai_kontrol menu = @menu); set @haftaici_max =(select haftaici_max dbo.mesai_kontrol menu = @menu); set @haftasonu_min =(select haftasonu_min dbo.mesai_kontrol menu = @menu); set @haftasonu_max =(select haftasonu_max dbo.mesai_kontrol menu = @menu); ---------------------------------------- ----------------------------------------------- if(@gun in ('pazartesi', 'sali', 'carsamba', 'persembe', 'cuma')) if(@tod>=@haftaici_min , @tod<=@haftaici_max ) begin set @mesai_durum='mesai_ici' set @hangi_gun=@gun select @mesai_durum mesaidurumu select @hangi_gun gun end else begin set @mesai_durum='mesai_disi' set @hangi_gun=@gun select @mesai_durum mesaidurumu select @hangi_gun gun end ------------------------------------------- ------------------------------------------- else if(@gun in('cumartesi','pazar')) if(@tod>=@haftasonu_min , @tod<=@haftasonu_max ) begin set @mesai_durum='mesai_ici' set @hangi_gun=@gun select @mesai_durum mesaidurumu select @hangi_gun gun end else begin set @mesai_durum='mesai_disi' set @hangi_gun=@gun select @mesai_durum mesaidurumu select @hangi_gun gun end end
Comments
Post a Comment