on 02-03-2009 1:11 PM
Hi, I am using XML SQL Document format to send actions to an Oracle database.
My concern is this: I need to insert several invoice header lines then after that I need to insert the Invoice position lines and then, at the end, i need to excecute an store procedure.
If I do all that in one message, each sentence is treated by the DB in order ? or is it treated in paralel?
It is possible to excecute StatementName1 StatementName2 and StatementName3 in that exact order?
An example of the xml message is this...
<Message>
<StatementName1>
<dbTableName action=u201DINSERTu201D>
<table>TABLE1</table>
<access>
<col1>val1</col1>
<col2>val2</col2>
</access>
<access>
<col1>val11</col1>
</access>
</dbTableName>
</StatementName1>
<StatementName2>
<dbTableName action=u201DINSERTu201D>
<table>TABLE2</table>
<access>
<col1>val1</col1>
<col2>val2</col2>
</access>
<access>
<col1>val11</col1>
</access>
</dbTableName>
</StatementName2>
<StatementName3>
<storedProcedureName action=u201D EXECUTEu201D>
<table>realStoredProcedureeName</table>
<param1 [isInput=u201Dtrueu201D] [isOutput=true] type=SQLDatatype>val1</param1>
</storedProcedureName >
</StatementName3>
</Message>
Hi,
I'm not sure that it can be done in parallel, it all depends in your ABAP program that is designed to execute the SQL statement. But in our scenario, the execution is in order.
Hope this helps,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I just want to clarify I need to execute the sentences serially, also i am using a JDBC adapter in XI to do the connection.
On the other hand I believe the order of excecution has relation with the DB and not with the SAP program, because once the message is received by de DB, how it treats it is a responsability of the DB.
Thanks.
Mariano.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.