Skip to Content
0
Former Member
Oct 20, 2005 at 09:02 AM

Call Stored Prodcedure

18 Views

Hi,

we try to solve some problems over stored prodcedures on a DB. I create a datatyp and a mapping that ends in following xml stream:

<?xml version="1.0" encoding="UTF-8" ?>

<p3:MT_RATE_UPDATE xmlns:p3="http://xi.poc">

<StmName>

<sp_pVTPaymentSapChangeStatus action="EXECUTE">

<table>pVTPaymentSapChangeStatus</table>

<PAY_ORDINAL_IDi isInput="true"

type="INTEGER">46602</PAY_ORDINAL_IDi>

<PAY_STATUS_NEWi isInput="true" type="INTEGER">5</PAY_STATUS_NEWi>

<PAY_POSTED_CLIENTi isInput="true" type="INTEGER">1</PAY_POSTED_CLIENTi>

<PAY_POSTED_ACCOUNTING_AREAi isInput="true" type="INTEGER">1000</PAY_POSTED_ACCOUNTING_AREAi>

<PAY_POSTED_FISCAL_YEARsi isInput="true" type="SMALLINT">2005</PAY_POSTED_FISCAL_YEARsi>

<PAY_POSTED_VOUCHER_NOn isInput="true" type="NUMERIC">3000000269</PAY_POSTED_VOUCHER_NOn>

<PAY_POSTED_DATEdt isInput="true" type="DATETIME">2005-10- 0701:01:01.0</PAY_POSTED_DATEdt>

</sp_pVTPaymentSapChangeStatus>

</StmName>

</p3:MT_RATE_UPDATE>

I seems that it works fine, but I did not get back any Acknowledgement... Did I made something wrong on XI site?

THX Matt