B1i Integration Framework - Problems to call an HANA stored procedure

[former_member327899]

Hi experts,

I have problems to call an HANA stored procedure by a JDBC call atom. I'm using B1i version 2.0.

Someone can help me to understand the correct way to settings the XSL transformation atom for JDBC call?

From Hana studio I use this syntax "call APR00_DOC_EXPNS_MUSTHAVE(17,47,'A',Null);" and it works well.

In B1i I use this template:

<jdbc:Envelope>

<jdbc:Body>

<jdbc:CallStoredProcedure throwException="true">

<jdbc:Name>APR00_DOC_EXPNS_MUSTHAVE</jdbc:Name>

<jdbc:ReturnValueType/>

<jdbc:Parameters>

<jdbc:Parameter output="false">

<jdbc:Type/>

<jdbc:Value>17</jdbc:Value>

<jdbc:Scale/>

</jdbc:Parameter>

<jdbc:Parameter output="false">

<jdbc:Type/>

<jdbc:Value>47</jdbc:Value>

<jdbc:Scale/>

</jdbc:Parameter>

<jdbc:Parameter output="false">

<jdbc:Type/>

<jdbc:Value>A</jdbc:Value>

<jdbc:Scale/>

</jdbc:Parameter>

<jdbc:Parameter output="true">

<jdbc:Type/>

<jdbc:Value>Null</jdbc:Value>

<jdbc:Scale/>

</jdbc:Parameter>

</jdbc:Parameters>

</jdbc:CallStoredProcedure>

</jdbc:Body>

</jdbc:Envelope>

What values must I indicate for "Type" and "Scale" options?

Thanks in advance for your help.

Best regards