stored procedure : how to call SP in sender JDBC adapter for mysql

[Former Member]

HI friends ,

we have JDBC---->XI--

---

>SAP scenario. For some business requirement, we have to call STORED PROCEDURE , please let me know how to call SP in sender JDBC adapter for mysql .

Thanks

mojib

[Former Member]

Hi Mohamad,

In this case, I think you have not possible to call the stored procedure as a query in your JDBC sender adatpter.

if you must call the stored procedure, if convert into stored procedure to function. so if you call the function ,it possible to write a query.

check with your database guys about this.

Thank you

Sateesh

[Former Member]

Hi Mojib,

Please create a sample stored procedure like this which contains select statement and in communication channel give

wite stored procedure name only to sql query statment and in update statement write <test>.

I am executing this stored procedure successfully.

Create Proc GetResultX As

Begin

Select * From TESTX

End

Execute statement for stored procedure is :

Exec GetResultX

Regards

Laxmi Bhushan Jha

Rewards point if found usful

I have given same answer to one of the same thread

[Former Member]

Hi,

Try to use this structure. Just rename the details that will suite your stored procedure structure.

<StatementName5>

  <storedProcedureName action=u201D EXECUTEu201D>

      <table>realStoredProcedureeName</table>

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

  </storedProcedureName > 

</StatementName5>

Regards,

Alfred

Edited by: alfred_A_sap on Sep 30, 2010 10:52 AM

[Former Member]

Hi,

similar query has discussed in this thread-

regards,

francis