Skip to Content
author's profile photo
Former Member

Multiple calls using a stored procedure - JDBC adapter

Hi,

Scenario - RFC internal table to JDBC stored procedure

The stored procedure accepts parameters. I am able to send one of the records from the internal table to the stored procedure.

Is is possible to send multiple calls to the stored procedure or to pass the whole table to the stored procedure?

Thanks,

Leanne

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    author's profile photo
    Former Member
    Oct 15, 2007 at 06:40 AM

    You can create multiple STATEMENT rows based on your requirement. This will call your SP that many number of times.

    STATEMENT tag will occur for every insertion that you want to happen.

    <StatementName>

    <storedProcedureName action=” EXECUTE”>

    <table>realStoredProcedureeName</table>

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

    </storedProcedureName >

    </StatementName>

    Thanks

    Satish

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 15, 2007 at 06:20 AM

    Hi Leanne

    you can pass any number of input parameters to the Stored procedure.

    have a look on this bolgs it will help you.

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

    Passing the whole internal table i do not think so it is a better idea.

    Thanks

    sudhir sharma

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sudir,

      Thans for the feedback. Please confirm the following: What you are saying is that I should use a stored procedure passing across several parameters instead of sending a table.

      Thanks,

      Leanne

  • author's profile photo
    Former Member
    Oct 15, 2007 at 06:46 AM

    Hi

    you need the format of Datatype for stored procedures.

    kindly go through this link..i think it will give the answer to your query

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

    The Data types will correspond to the xmls by reading the article http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

    http://help.sap.com/saphelp_erp2005vp/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

    Thanks!!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Keerthi,

      In simple terms, a stored procedure is a 'program' written by the 3rd party ie. SQL developer. This 'program' can execute serveral SQL commands.

      I hope this makes sense.

      Regards,

      Leanne

  • author's profile photo
    Former Member
    Oct 15, 2007 at 08:49 AM

    Hi

    my idea says that instead of passing the whole table in the SP them how whould we handle this in XI , as we can handle passing the input parameters .

    secondly passing the whole table structure in SP then how whould u define ur parmeters

    Thanks

    sudhir sharma

    Add comment
    10|10000 characters needed characters exceeded