sql server - Display data with stored procedure -
i have following stored procedure..
create procedure usp_com_mst_del( @code int = 0, @name varchar(50)= '', @type int =0, @operation varchar(20) ='', @message varchar(200) output, @status varchar(2) output ) begin if(@operation = 'display') begin if not exists (select * com_mst com_ctcd = @type) begin set @status = '0' set @message = 'no record found' end else begin set @status = '0' set @message = 'no record found' select * com_mst com_ctcd = @type end end end
but when try run procedure.. shows error
usp_com_mst_del @operation = 'display'
error:
procedure or function 'usp_com_mst_del' expects parameter '@message', not supplied.
you need specify output parameters should go to.
declare @message varchar(200), @status varchar(2) exec usp_com_mst_del @operation = 'display', @message output, @status output
(which error message saying)
Comments
Post a Comment