PI Receiver Stored Procedure Format

[former_member287165]

Hi Experts,

We are developing JDBC adapter interface which will update every day sales order to database.

As the amount of data are in thousands and we were getting locking use while using Insert command , we have switched to Stored Procedure approach,

We are send all the sender data under single node in form of XML. But are database end , we are getting error as XML parameter missing with below error in database log.

Below is the XML which is being sent to Database from PI to call stored procedure

Please can someone help me out to understand the if the structure i have created is correct and which parameter is Database expecting when we are sending this.

Regards

Avichal

[iaki_vila]

Hi Avichai,

If i understand your requirement you want to pass a XML to a parameter in a stored procedure, then you need to pass the XML like CDATA to the target node. With the CDATA sentence PI takes the XML like text and PI can send it to single node in a XML like its value.

Check Amit's example in this thread

Regards.