Stored Procedure

<b>what is Stored Procedure ?</b>

Stored proceedures are precompiled piece of SQL code writetn on your DB..

http://en.wikipedia.org/wiki/Stored_procedure

Instead of "SQL Statement" you can mentioned the name of stored procedure. For example instead of writing updation code in SQL statement section you can use a stored procedure for the same purpose.

Check this SAP file (<SQL-Select-Statement> and <SQL-Select-Statement>) sections:

http://help.sap.com/saphelp_nw04/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/content.htm

The Store procedure converts the table resulting from the query SQL statement into a valid XML document and sends it to the Integration Engine. The document looks like this:

<resultset>

<row>

<column-name1>column-value<>

<column-name2>column-value<>

<column-name3>column-value<>

</row>

<row>

<column-name1>column-value<>

<column-name2>column-value<>

<column-name3>column-value<>

</row>

</resultset>

<b>why we use Sotred procedure?</b>

store procudeure are used to retrive the datas from DB which are in Table format into XML format.

http://www.functionx.com/sqlserver/Lesson16.htm

<b>what actions need to be taken care for DB and JBDC adapter( sender / reciver) side?</b>

HTTP to stored Procedure(JDBC) scenario.

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

File to File scenario(store procedure implemented)

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

Also check

Check this Blog

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

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 Sriram's 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

regards

biplab

Use a Good Subject Line, One Question Per Posting - Award Points