Receiver JDBC Procedures.

[Former Member]

I am sending the Payroll information from a FLAT file to a Database thru XI. On the Receiver side I need to call a procedure, that will post the incoming records into the Database.

If there is any blog that explains how to build the Receiver JDBC ADAPTER calling a Procedure?

Thanks.

[Former Member · Accepted solution]

Hi,

To install the external drivers refer to following how to guide.

https://websmp106.sap-ag.de/~form/sapnet?_SHORTKEY=01200252310000071155&; - How to install external drivers

Thanks,

Prateek

[Former Member · Accepted solution]

Thanks Chandra. More precisely, in the Receiver JDBC adapter, where should I mention the PROCEDURE name that I am going to call?

[moorthy · Accepted solution]

Hi Mohan,

It should be executed in the "EXECUTE" method in the action attribute of Data Type. ANd stored procedure name is mentioned in the Data Type it self.

Ie. DT_Eg

Statement

Stored Procedure Name

Action

Like this

Just go thru following link-

Hope this helps,

Regards

Moorthy

[Former Member]

Hi,

In this scenario you would be using a receiver JDBC adapter.

In the adapter parameters, specify the action as execute.

In the data type that you have created, under the <action = "execute"> segment, specify the stored procedure you need to execute in the <table> </table> tag.

Hope this helps.

Regards,

Smitha.

[former_member91687]

Hi Mohan,

You can execute a stored procedure in XI using a JDBC receiver adapter. For this, the value for the action attribute will be EXECUTE, and the value under the table name will be the name of the STORED PROCEDURE.

You can refer to this blog about stored procedures:

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

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

To configure your receiver jdbc adapter follow the steps given here:

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

The variables declared for the stored proceudre has to be passed to the adapter. For the exact specification on how the target message should look like, just check the link below under StatementName5.

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

Regards,

Chandra

Message was edited by: Chandravadhana