CALL Oracle-Procedure in BW over XI

[Former Member]

Hi all,

I want to call an Oracle-Procedure in the BW over XI. Further the procedure should get a number parameter and also return a number.

Can anyone please tell me if this should work. And if yes, how I can get it.

Thanks in foreward

Peter

[Former Member]

Thanks for the information, but I thought i have to use a proxy.

I have created a proxy and a proxy-class.

The implementation of my test-program looks like follows.

Is my way right or totally false?

Thanks

REPORT zproxy_test.

DATA:

• Reference variables for proxy and exception class

lo_clientproxy TYPE REF TO zco_mi_pp_masterdata_loa,

lo_sys_exception TYPE REF TO cx_ai_system_fault,

lo_appl_exception TYPE REF TO cx_ai_application_fault,

• Structures to set and get message content

ls_request TYPE zmt_pp_masterdata_load_msg,

ls_response TYPE zmt_pp_masterdata_loadres_msg.

• ls_request-mt_pp_masterdata_loadrep-start = 't'.

TRY.

• create proxy client

CREATE OBJECT lo_clientproxy.

CALL METHOD lo_clientproxy->execute_synchronous

EXPORTING

output = ls_request

IMPORTING

input = ls_response.

CATCH cx_ai_system_fault INTO lo_sys_exception.

CATCH cx_ai_application_fault INTO lo_appl_exception.

ENDTRY.

[bhavesh_kantilal]

Hmm. not I am confused.

I have not worked much with XI BW integrations and hence might not be able to provide you the best answer.

Yes proxy is the way to integration BW with XI.

As your question deals with the Oracle SP; I thought you are using JDBC adapter to talk to a Oracle Database directly. Now I am not sure what your exact requirement is.

If there is something specific in BW called Procedure, well then I fear I do not have the answer.

Regards

Bhavesh

[Former Member]

Hi,

what i need exactly is:

I have a manufacturing system (MES) and for those db I have a procedure which gets a parameter and returns a parameter. I want to call the procedure in an Report in BW. In the Report I like to give the procedure a parameter and I need the return parameter for further working.

I'm thankful for every little help

[bhavesh_kantilal]

Is this your Scenario?

BW - XI - MES (Oracle DB)

If yes, then you are on the right target.

BW will trigger the call to XI using the proxy and then you will call the Procedure from Oracle using the blog I have listed above.

The response can then be mapped back to the proxy response and this will be sent back to your proxy where you can what is needed thereon.

Regards

Bhavesh

[bhavesh_kantilal]

Hey Peter,

Not sure if this would work differently with BW,. but if you have access to the Oracle Database and XI needs to call the Stored Procedure syncrhously, then this is definitely possible using a receiver JDBC adapter.

Check this blog for a understanding of how the XML in XI would look for making a call to JDBC adapter to call Stored Procedures.

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards

Bhavesh