cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC

Former Member
0 Kudos

i am working on JDBC at the sender side & IDOC in the reciever side..

my question is how to use stored procedures in JDBC when its in the sender side..

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member307485
Active Participant
0 Kudos

Hi Varun,

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

Regards,

Divya

Edited by: Divya Nambiar on Jun 17, 2009 11:06 AM

Former Member
0 Kudos

Hi Varun,

It can be done through Excute/Call statement in JDBC sender adapter. Please check the below thread.

Thanks & Regards,

Senthil.

MichalKrawczyk
Active Contributor
0 Kudos

Hi,

>>> is how to use stored procedures in JDBC when its in the sender side..

by specifying an EXECUTE statement in the Query SQL Statement field

Regards,

Michal Krawczyk

prateek
Active Contributor
0 Kudos

Table functions could be a way of achieving your requirement.

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

Regards,

Prateek