Posting Null Value to stored procedure input parameter

[Former Member]

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.

[Former Member]

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.

[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.

[prasanna_shanmugasundaram]

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