Skip to Content
avatar image
Former Member

Posting Null Value to stored procedure input parameter

Hello,

Following is the message that I am trying to post to SQL server 2005 stored procedure input parameter from SAP PI

<MoveWeightNett isInput="true" type="varchar">4.890</MoveWeightNett>

<UnitOfWeight isInput="true" type="varchar">KG</UnitOfWeight>

<PurchaseOrders isInput="true" type="varchar" />

<TimeType isInput="true" type="varchar">WSHDRLFDAT</TimeType>

<MoveDateTime hasQuot="no" isInput="true" type="varchar" />

<DeliveryType isInput="true" type="varchar">DIG</DeliveryType>

<SenderSystem isInput="true" type="varchar">WCD320</SenderSystem>

For the MoveDateTime, I need to pass a NULL object to the stored proecdure. Can you please let me know how this can be done? The Interpretation of empty string values as NULL does not work. It sends NULL as a String.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jul 14, 2009 at 05:19 AM

    You got to check this in your SQL table. Check the SQL table if the MoveDateTime column is nullable.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 14, 2009 at 02:59 PM

    Hi.

    Please verify if MoveDate time is nullable and don't send this parameter.

    Or maybe you can add this on the element xsi:nil="true"

    Luis.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks to All,

      I did try these options but it didn't work. ultimately I created a separate mapping just to create an execute query to insert the null as an object to the database.