How to execute Stored Procedure?

[Former Member]

Can anybody provide a step by step procedure for setting

up Receiver JDBC Aadapter to call a STORED PROCEDURE?

We are using SQL SERVER DB.

Thanks in Advannce

[Former Member · Accepted solution]

Hi Venu,

Below are the steps you need to perform

1.

CREATE PROCEDURE usp_insert

@name char(10) ,

@company char(10)

AS

INSERT INTO Rahul (Name, Company)

values (@name,@company)

GO

This is a sample stored procedure (usp_insert) which is used to insert values for “name” and “company” into the table “Rahul”.

If the stored procedure is already created note its name.

2. After creating the stored procedure move to XI to do the further configuration.

3.Then the crucial part is message mapping

Take care of the following things

Mappings:

action -> EXECUTE (Constant)

Table -> usp_insert (Constant) –“It is the stored procedure name”

4.In the integration directory everything is similar. Create the receiver jdbc channel in the normal manner how you were creating for the scenario without stored procedure.

I hope this information solves a lot of your queries.

Thanks and Regards

Rahul Nawale

[Former Member · Accepted solution]

Thanks

[Former Member]

Hi Venu,

On the JDBC end you can write a stored procedure to make your data update more efficient.

Go through this blog for stored procedures.

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

I hope this helps.

Regards,

Abhy

[bhavesh_kantilal]

Venu,

Take a look at this link for the document format and its explantion,

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

<i><root>

<StatementName5>

<storedProcedureName action=” EXECUTE”>

<table>realStoredProcedureeName</table>

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

</storedProcedureName >

</StatementName5>

</root></i>

Regards,

Bhavesh

[Former Member]

Hi Venu,

These threads will also help you..

cheers,

Prashanth

[moorthy]

HI,

Have a look into this-

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

Regards,

moorthy