How to use Stored Procedure Call in Sender JDBC adapter

[Former Member]

Hi All,

Could someone send me a blog on how to use Stored Procedure call in Sender JDBC adapter?

Xier

[former_member181962 · Accepted solution]

/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

[Former Member]

Hi Xler

refer these links

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

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

Also, you can check Sriram's blog for executing Stored Procedures,

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

/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

This blog might be helpfull on stored procedures for JDBC

JDBC Stored Procedures

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

Please go through these threads and see if it helps...

Thnaks !!

[prateek]

Make sure that u r not using Oracle at sender. In this case use of stored procedures cant b done bcoz XI expects recordset while Oracle stored proc returns Cursor.

The method to call stored proc would remain same except the action=EXECUTE

Regards,

Prateek