on 09-18-2008 2:37 PM
Dear frndz,
I had a doubt for which i can't get the correct answer from the sdn....
I am receiving data(Internal table) from the SAP system using the outbound Proxy. And Passing it to Oracle system using the inbound JDBC. I want to know can i update the oracle table, passing the data in 1 to unbounded or i should loop through the internal table in sap and then pass one by one to the inbound JDBC. Please clarify. If u not get my query plz revert back.
thanks in advance
Karthikeyan
answered
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you can update multiple records in DB .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi !!
You can update mutiple records in one statement just make the occurance to unbounded in your data type declartion for JDBC reciver .
Rgds
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If Your Structure looks like this means
Header-----
ID
Details
rec1
rec2
rec3
.....
You can make the Details as Unbounded and hold the Multiple Records from SAP via Proxy.
In the receiver side also make the Structure as Unbounded to hold the Multiple Records
Thats it
Regards
Seshagiri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
An Oracle stored procedure is a program stored in an Oracle database.
You can refer this link which helps you on how to create stored procedures in oracle:
Hi,
This is handled impliclty by the JDBC adapter depending on the transaction setting. Every Statement is executed as All Or None.
So if the Statement has multiple Access tags, then it is again All of the Access ( Rows in SQL terminoligies ) getting executed or none of them.
Check online help.sap, for "Document Formats of JDBC adapter"
Regards,
Bhavesh
Hi,
Normally for any JDBC scenario, the records must be passed in a single shot. If one of them fails, all record would be rollbacked.
If you pass record by record, the performance would be drastic as each time it will open a LUW and hit the database.
It is better to pass all records in single shot.
It is better to put 1.unbounded else if u loop the internal table the execution time from proxy to XI will be happening record by record which is not advisable
Regards,
Krish
Edited by: Krish on Sep 18, 2008 7:12 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.