cancel
Showing results for 
Search instead for 
Did you mean: 

stored procedure

Former Member
0 Kudos

Hi All,

could anyone exolain me what is stored procedure and where we use this one and why we use...

regards

Joshi

Accepted Solutions (1)

Accepted Solutions (1)

prateek
Active Contributor
0 Kudos

<i>could anyone exolain me what is stored procedure </i>

A stored procedure is a subroutine available to applications accessing a relational database system. Stored procedures (sometimes called a sproc or SP) are actually stored in the database.

Typical uses for stored procedures include data validation (integrated into the database) or access control mechanisms. Furthermore, stored procedures are used to consolidate and centralize logic that was originally implemented in applications. Large or complex processing that might require the execution of several SQL statements is moved into stored procedures and all applications call the procedures only.

<i>where we use this one</i>

In XI while configuring scenario involving JDBC adapter, u may use SP.

<i>why we use</i>

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

<i>http://en.wikipedia.org/wiki/Stored_procedure</i>

<i>[Reward if useful]</i>

Regards,

Prateek

Former Member
0 Kudos

thank you very much i got some idea ,if you have screenshots how we used please rpovide me.

Former Member
0 Kudos

Hi Nitesh,

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

Regards,

Subhasha Ranjan

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Nitesh,

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.

Regards,

Subhasha Ranjan

former_member529475
Active Contributor
0 Kudos

Hi Nitesh

Stored procedures are used mostly in Synchronous transmission.

The data coming from source is stored for specific period of time at the destination and sent back to the source.

Just have a look at these links:

/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

Cheers..

Vasu

<i>** Reward Points if found useful **</i>