Multiple calls using a stored procedure - JDBC adapter

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

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

[Former Member]

hi all,

what is the use of stored procedure,where it is used in jdbc,where dhould we write our code?

regards,

keerthi

[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

[Former Member]

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

[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