stored procedure?

[Former Member]

Hi expertsu2026u2026..

What is a stored procedure? where exactly in can occur? for which scenario's we well use this stored procedure?

thank you

[former_member200962 · Accepted solution]

Any chance you searched like this: https://forums.sdn.sap.com/search.jspa?threadID=&q=%22stored+procedure%22&objID=f44&dateRange=all&nu...

And found something like this:

Regards,

Abhishek.

[Former Member]

refer [; will answer your Q

Edited by: Kubra fatima on Sep 1, 2009 12:50 PM

[former_member187339]

Hi,

>>What is a stored procedure?

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

>> where exactly in can occur?

In Database

>>for which scenario's we well use this stored procedure?

Where directly fetching values from table doesn't serve the purpose. One situation can be to fetch value from two three tables and after some basi manipulation in content I need to send the record to XI. So these fetching and data manipulation can be done in DB side itself by the stored procedure.

Regards

Suraj