Problem with web service to oracle (insert data and return result set).

[Former Member]

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

[Former Member]

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

http://www.oracle.com/technology/tech/webservices/htdocs/samples/dbwebservice/DBWebServices_PLSQL.ht...

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

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/336365d3-0401-0010-9884-a65...

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

[Former Member]

Hi..

Follow the below link. Hope that will help you. You can use synchronous soap to jdbc adapter for this.

Regards,

Leela

[Former Member]

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