BizTalk Stored proc raising error

system.invalidoperationexception: invalid command sent executexmlreader.  command must return xml result.

 

system.data.sqlclient.sqlexception (0x80131904): procedure or function 'inserttbl_lookup_duke_membership' expects parameter '@mrn', not supplied.

alter procedure [dbo].[inserttbl_lookup_ezcap_membership] (

      @mrn [varchar](80),

      @firstname [varchar](30),

      @lastname [varchar](40),

      @middlename [varchar](25) = null,

      @dob [date],

      @memberid [varchar](20),

      @gender [varchar](1),

      @extpayerid [varchar](36),

      @hpcode [varchar](10),

      @benopt [varchar](20),

      @benopteffdate [date],

      @benoptenddate [date] = null

) as

begin

      -- set nocount on added prevent result sets from

      -- interfering select statements.

      set nocount on;

     

      declare @currenttime datetime;

      set @currenttime = getdate();

 

      insert into dbo.tbl_lookup_ezcap_membership

      (

            mrn,

            firstname,

            lastname,

            middlename,

            dob,

            memberid,

            gender,

            extpayerid,

            hpcode,

            benopt,

            benopteffdate,

            benoptenddate,

            createtimestamp,

            modifiedtimestamp

      ) values (

            @mrn,

            @firstname,

            @lastname,

            @middlename,

            @dob,

            @memberid,

            @gender,

            @extpayerid,

            @hpcode,

            @benopt,

            @benopteffdate,

            @benoptenddate,

            @currenttime,

            @currenttime

      );

     

end

 

 

go

 

should make work  in biztalk? please urgent

 

---

mbh

hi,

the stored procedure created/modified needs required parameter @mrn, not passed.

pass parameter or add default value variable in stored procedure. should work.

rachit

BizTalk Server  >  BizTalk Server General