How to send data into two table (oracle system )

[Former Member]

Hi

Experts

How to send data into two table (oracle system ) .

from a single file structure at sender and reciver 2 tables should be updated

i need file structure for source as well as for reciver

[Former Member]

Hi aravind,

Document Formats for the Receiver JDBC Adapter

http://help.sap.com/saphelp_erp2005vp/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

<StatementName2>
<dbTableName action=u201DINSERTu201D>
<!-- TABLE 1 -->
<table>realDbTableName_1</table>
<access>
<col1>val1</col1>
<col2>val2</col2>
</access>
<access>
<col1>val11</col1>
</access>
</dbTableName>  
<!-- TABLE 2 -->
<table>realDbTableName_2</table>
<access>
<col1>val1</col1>
<col2>val2</col2>
</access>
<access>
<col1>val11</col1>
</access>
</dbTableName>

</StatementName2>

Regards Mario

[Former Member]

Hi,

Inserting data with single structure for two tables,Create a Statement with 0-Unbounded.Dublicate the Receiver Statment Structure.If you create access with 0-Unbounded then you can able to insert multiple records with each table.

<StatementName1>

<dbTableName action=u201DINSERTu201D>

<table>TABLE1</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</dbTableName>

</StatementName1>

Dublicate the statment.

<StatementName1>

<dbTableName action=u201DINSERTu201D>

<table>TABLE2</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</dbTableName>

</StatementName1>

Regards,

Prakasu

[Former Member]

Hi Aravind,

There are two ways to do it.

1. You need to have two message mapping, add one more line in your interace determination.

2. Or in the same message mapping.

<Statement1>

<tag1>

<action>INSERT</action>

<table>Table1</table>

<access>

<field1>

<field2>

......

......

<Statement2>

<tag2>

<action>INSERT</action>

<table>Table2</table>

<access>

<field1>

<field2>

......

......

For more details on the sender and receiver structures check the below link. Also note action is an attribute.

http://help.sap.com/saphelp_nw70/helpdata/en/48/d5a1fe5f317a4e8e35801ed2c88246/frameset.htm

-Regards,

Shamly

Edited by: Shamly MM on Aug 14, 2008 4:01 PM