Calling stored procedure multiple times in the JDBC receiver

[Former Member]

Hi,

I am calling the stored procedure(SP) to update a DB table in the JDBC receiver.

SP has 10 input parameters, and SP can receive one value for each parameter at a time.

In my case, i will have multiple rows to insert using SP.i.e multiple values for each parameter.

Its working correctly for a single value for each parameter, but when i have multiple values i want to call the SP multiples times.

Is this possible and how?

Thanks,

Varghese.

[Former Member]

Yes. what u said is right.

Have multiple statement tag and it will work out fine.

Thanks man.

[Former Member]

Hi Koen,

I tried using multiple statements and it gave an error.

Do you think it is possible.

For me the Adapter gave error says multiple arguments/types.

Thanks,

Varghese.

[Former Member]

Varghese,

I am quite sure this should be possible. Can you post the exact error message?

Kind regards,

Koen

[Former Member]

Varghese,

I think you can have multiple statements in the JDBC Adapter's XML, as in http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm.

Here the StatementName1 node can be inserted into your JDBC XML as often as you want.

Kind regards,

Koen

[Former Member]

Hi Varghese,

You mention that SP can receive only one value for each parameter at a time ie. only one set of records in one invocation.

You might want to modify the SP to handle multiple rows of record at a a time and try it out!!

Hope this helps,

Regards,

Vinayak Kamath