Re: passing sql stored proc param type of bit

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › passing sql stored proc param type of bit › Re: passing sql stored proc param type of bit

July 10, 2014 at 11:05 AM #26403
community-content

    Thank you.  The type of the schema is and was xs:boolean.  The diff between your code and mine is that I was returning Boolean and you're returning bool.  I changed the script to yours and the error message is different but still not working.  Error:  'Inner exception: Input string was not in a correct format.'  In the stack trace it is trying to do a StringToNumber and I don't understand why.  My message is this:

    <ns0:uspUpdateBizTalkrunDates xmlns:ns0="schemas.microsoft.com/…/dbo">

    <ns0:ProcessName>orchPractitionerSpecialties</ns0:ProcessName>

    <ns0:RunToDate>2014-07-10T08:34:20</ns0:RunToDate>

    <ns0:Successful>true</ns0:Successful>

    </ns0:uspUpdateBizTalkrunDates>

    types in the stored proc and schema respectively are:

    ProcessName – VarChar(100) – xs:string

    RunToDate – datetime – xs:dateTime

    Successful – bit – xs:boolean

    It is the send Shape that is throwing the error.  any other suggestions?  Thank you for your help!