Stored Procedure
Hi all,
I am new to this concept: Stored Procedure
what is Stored Procedure ?
why we use Sotred procedure?
what actions need to be taken care for DB and JBDC adapter( sender / reciver) side?
Really appreciate your response?
Thanks,
Hari
Former Member replied
<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