Stored Procedure

[Former Member]

Hi, expertsI need your opinion on the following topic.

How I can consume a stored procedure of Oracle from SAP PI 7.1 ? , I need know the basic steps to make this task on PI and I want to know if there is some way to do it using Native SQL.

I´ll be very grateful to hear your suggestions, Thank you.

[baskar_gopalakrishnan2]

You can consume stored procedure of oracle using PI through jdbc adapter. YOu have to construct target mesg structure as below...

<StatementName5>

<storedProcedureName action=u201D EXECUTEu201D>

    <table>realStoredProcedureeName</table>

<param1 [isInput=u201Dtrueu201D] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >  

  </StatementName5>

Refer these links

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

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi