passing the whole payload as a large string to JDBC receiver

[former_member373376]

Hello guys

My question is whether and how to pass the whole payload as single string to JDBC receiver for called procedure.

the string then will be read and manipulated  in the receiver side and sending some answer back.

is there a limitation of the size of the string ,it is a sync scenario , how is the max time  will PI be able to wait for not to time out

Thanks a lot

[former_member182412 · Accepted solution]

Hi Sameer,

Check below blog for length restriction.

2) If mapping output stored procedure XML characters exceeds more than 32k then Data base side they need to change coding in stored procedure to accepts more than 32k,I have faced this problem my data base team had fixed it.

Also check the other parts of the series.

Regards,

Praveen.