Stored Procedure

[Former Member]

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 · Accepted solution]

<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

[Former Member]

Hi,

Please Gothrough these Blogs

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

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

Reward Points If Helpful

Regards

Giri

[Former Member]

Ys, I t has been solved...

Thank you guys..

Regards,

Hari

[Former Member]

Hi,

Please Mark your thread as Solved & Assign Points

Regards

Giri

[Former Member]

hi hari,

Stored Procedure

http://help.sap.com/saphelp_nw04/helpdata/en/45/023c41325fa831e10000000a1550b0/frameset.htm

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

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

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

regards

Ramesh P

[nisarkhan_n]

A stored procedure is a subroutine available to applications accessing a RDBMS.

Usually stored procedure means several SQL statements that is under stored procedures and all applications call the procedures only. Multiple SQL statements are written in stored procedure and it can be called by single name rather than executing each statement separately.

why we use?

One of the usage is to prevent the query to directly write to the dateabase

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

Check these:

http://help.sap.com/saphelp_nw04s/helpdata/en/b0/676b3c255b1475e10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/frameset.htm

/people/laxman.molugu/blog/2006/08/13/integration-with-databases-made-easy-150-part-1

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

http://help.sap.com/saphelp_nw04/helpdata/en/45/023c41325fa831e10000000a1550b0/frameset.htm

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