Skip to Content
author's profile photo
Former Member

How to use Stored Procedure Call in Sender JDBC adapter

Hi All,

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

Xier

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Posted on Aug 21, 2007 at 12:26 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 21, 2007 at 03:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 21, 2007 at 04:02 AM

    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...

    how-to-execute-stored-procedure

    problem-with-jdbc-stored-procedure

    Thnaks !!

    Add comment
    10|10000 characters needed characters exceeded