on 12-03-2008 11:05 AM
Hello,
I already succeed to implement 2 kinds of scenarios like that:
A. Scenario the send parameters and received parameters.
B. Scenario that received table.
Now I have a problem
I try to implement scenario from web service to Oracle.
I need to send 2 parameters to the Oracle database and received to the web service result set.
Thank you for your help
Elad
Hi,
you want to push data from Oracle to XI rather than polling the database from XI and retrieving data.
You may consider exposing your outbound interface in XI as a web service and then calling the web service from the triggers in Oracle. Thus data would be passed from the Oracle trigger to XI over SOAP.
This link would help you on how to call web service from PL/SQL
These links would help you on how to expose a web service from XI.
http://help.sap.com/saphelp_nw04/helpdata/en/31/daa0404dd52b54e10000000a1550b0/frameset.htm
You can write the trigger for the appropriate action (INSERT, UPDATE, DELETE) on the database table and then call the web service.
If you have a WSDL or location of the WSDL for your OracleDB, this is possible. Check out the following link to the SAP Help on Web Services. It should cover what is needed for both ABAP and Java on WEB AS 6.40
Check this link
http://help.sap.com/saphelp_erp2004/helpdata/en/ba/f21a403233dd5fe10000000a155106/frameset.htm
regards,
Surya
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.
Hello,
I tried to implement without succeed the blog about the synchronize scenario between JDBC and web service.
The problem is that I send these 2 parameters to stored procedure and not to table. And from this stored procedure I received the data.
I add this stored procedure:
/******************** GET_PL_LIST *******************************
GET_PL_LIST
return price master list for this user group teritry
e_usrgrp1 - user group can be region or teritory
e_usrgrp12- user group can be region or teritory
*********************************************************************/
FUNCTION GET_PL_LIST(
e_usrgrp1 IN varchar2,
e_usrgrp2 IN varchar2
)RETURN price_master_tab PIPELINED;
Elad
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.