cancel
Showing results for 
Search instead for 
Did you mean: 

Invoking Oracle stored procedures from within a JDBC channel for PI 7.1

Former Member
0 Kudos

Hi ,

Can anybody tell me that is it possible to invoke Oracle stored Procedure from within a JDBC sender channel for PI 7.1.

Its working in XI3.0 and XI 7.0 for Oracle DBMS versions >= 10.2.x. But I am not sure,whether it will work for PI 7.1 also.

Thanks & Regards,

Saru

Accepted Solutions (1)

Accepted Solutions (1)

rajasekhar_reddy14
Active Contributor
0 Kudos

Hi,

It wil work ,use EXECUTE statement to cal stored Procedure.

Regards,

Raj

Former Member
0 Kudos

Hi Raj,

Can you provide any document or link related to this?

Currently I am referring SAP note 941317 for this, but it is given for XI 3.0 and XI 7.0. not for PI 7.1.

Regards,

Saru

rajasekhar_reddy14
Active Contributor
0 Kudos

HI,

refer below link,there is no much difference in PI7.1 ,executing stored procedure is same .

http://help.sap.com/saphelp_nwpi71/helpdata/EN/44/7b72b2fde93673e10000000a114a6b/content.htm

Regards,

Raj

Former Member
0 Kudos

Hi,

In addition to above link refer below blog as well.

/people/luis.melgar/blog/2008/05/13/synchronous-soap-to-jdbc--end-to-end-walkthrough

The method to access stored procedures in PI 7.1 is same as that in PI 7.0.

Hope this helps.

Regards,

Siddhesh S.Tawate

Answers (0)