Scenario RFC2JDBC

[diegobruno_castrodasilva]

Hello guys!

My scenario is composed of RFC2JDBC. On the side JDBC, one procedure is executed.

My question: Would it be possible to pass one table as parameter for the procedure?

Thank you.

[diegobruno_castrodasilva]

Hi Carlos.

Thanks for helping above.

I need to pass multiple records to one procedure to perform the same insert in a database.

However need perform a delete on first export.

It would be possible without procedure?

[Former Member]

hi diego,

you can create a mtp like this:

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

<ns1:MTP_XXX xmlns:ns1="http://XXX/XXXX/XXXX">

<Statement_Delete>

<TABLENAME action="DELETE">

</TABLENAME>

</Statement_Delete>

<Statement>

<dbTableName action="INSERT"><table>TABLENAME</table>

<access>

<field1></field1>

</access>

</dbTableName>

</Statement></ns1:MTP_XXX>

Two statements in one xml.

This will execute 2 actions.

att.

[Former Member]

hi diego,

if u are using PI 7.1 or previous, is not possible pass a table with parameter.

You can pass n parameters like one register.

good luck.