on 04-02-2014 5:06 PM
Dear friends,
I have a scenario SAP <-> PI <-> Oracle DB. Its a synchronous scenario...
I get 3 fields from SAP and the structure looks like this:
<ns0:TestReq">
<Table> 1..n
<New/>
<Old/>
<Date/>
</Table>
</ns0:TestReq>
Ive to insert this structure as an array into a DB.
The Package.Stored Procedure looks like this
Test.testing ( updatetable IN Update_Table,
errortable OUT Update_Connect_Table,
errorcode OUT VARCHAR,
)
Can you please help me how to achive this? How can I insert this structure directly into a table as an array and keeping in mind with performance, because it can be alot of records at once.
Thank you in advance,
Kind regards,
John
Anyone any idea how to achieve this?
My scenario is to call the SP and within this SP I have to give data as an array to a DB table.
Can you help me how to do this?
Thank you in advance,
John
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hareesh,
That right, I'm calling a stored procedure and within this stored procedure I've to insert the data into a DB table.
The DB guys told me to process the data as an array and not XML...
Can you tell me how to insert the data of those 3 fields in a table within a stored procedure as an array? And what kinda type do I have to define?
How would the target structure to the DB looks like?
I appreciate your help,
Kind regards,
John
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.